Difference between revisions of "Working With Numeric Data in Recital"

From Recital Documentation Wiki
Jump to: navigation, search
(Working With Numeric Data in Recital)
(Numeric Conversion Functions)
Line 28: Line 28:
 
===Numeric Conversion Functions===
 
===Numeric Conversion Functions===
 
* [[ABS()|abs()]] - return the absolute value of a numeric
 
* [[ABS()|abs()]] - return the absolute value of a numeric
 +
 +
<pre>
 +
numeric = abs(numeric)
 +
</pre>
 +
 
* [[CAST()|cast()]] - perform data type conversion
 
* [[CAST()|cast()]] - perform data type conversion
 
* [[CHR()|chr()]] - perform numeric to ASCII character conversion
 
* [[CHR()|chr()]] - perform numeric to ASCII character conversion

Revision as of 13:48, 22 January 2010

Working With Numeric Data in Recital

Certain set commands change the display format of numeric data:

  • set decimals - specify the number of decimal places to be displayed
set decimals to <places as numeric>
  • set fixed - determine whether the number of decimal places displayed is fixed
set fixed on | off
  • set point - specify the character to be used as the decimal point
set point to [<point as character>]
  • set separator - specify the character to be used to mark thousands
set separator to [<separator as character>]

Numeric Conversion Functions

  • abs() - return the absolute value of a numeric
numeric = abs(numeric)
  • cast() - perform data type conversion
  • chr() - perform numeric to ASCII character conversion
  • ctrl() - return the numeric value of a control character
  • currency() - perform numeric to currency string conversion
  • etos() - perform expression to string conversion
  • int() - return the integer value of a numeric
  • str() - perform numeric to string conversion
  • strzero() - perform numeric to zero left-padded string conversion
  • transform() - perform expression to string conversion based on a picture formatting clause
  • val() - perform string to numeric conversion

Miscellaneous Numeric Functions

  • acos() - calculate the angle size in radians of a cosine
  • asin() - calculate the angle size of any given sine value
  • atan() - calulate the angle size of a given tangent value
  • atn2() - calculate the angle size for the specified cosine and sine values of a given point
  • between() - determine whether an expression is between two other specified expressions
  • celing() - calculate the smallest integer that is greater than or equal to a given value
  • cos() - calculate the cosine of an angle in radians
  • dtor() - perform degree to radian conversion
  • exp() - calculate exponential value
  • floor() - calculate the largest integer that is less than or equal to a given number
  • lennum() - calculate the length of a numeric value
  • log() - calculate natural logarithm value
  • log10() - calculate base 10 logarithm value
  • max() - calculate the greater of two values
  • min() - calculate the lesser of two values
  • mod() - calculate the division remainder
  • percent() - calculate percentage
  • pi() - return the value of pi
  • rand() - return a random number
  • round() - return a rounded numeric
  • rtod() - perform radian to degree conversion
  • sign() - return the sign of a numeric value
  • sin() - calculate the sine of an angle in radians
  • sqrt() - calculate a square root
  • tan() - calculate the tangent of an angle in radians

Miscellaneous Financial Functions

  • cagr() - calculate compound annual growth rate
  • fv() - calculate the future value of a periodic investment
  • payment() - calculate the payment on a loan
  • pmt() - calculate the payment on a loan
  • pv() - calculate the present value of equal regular payments on a loan