Difference between revisions of "Working With Numeric Data in Recital"
From Recital Documentation Wiki
Barrymavin (Talk | contribs) (→Summary) |
Yvonnemilne (Talk | contribs) (→Working With Numeric Data in Recital) |
||
| Line 1: | Line 1: | ||
==Working With Numeric Data in Recital== | ==Working With Numeric Data in Recital== | ||
| − | + | Certain [[:Category:Set Commands|set commands]] change the display format of numeric data: | |
| − | + | ||
| − | + | * [[SET DECIMALS|set decimals]] - specify the number of decimal places to be displayed | |
| + | <pre> | ||
| + | set decimals to <places as numeric> | ||
| + | </pre> | ||
| + | |||
| + | * [[SET FIXED|set fixed]] - determine whether the number of decimal places displayed is fixed | ||
| + | |||
| + | <pre> | ||
| + | set fixed on | off | ||
| + | </pre> | ||
| + | |||
| + | * [[SET POINT|set point]] - specify the character to be used as the decimal point | ||
| + | |||
| + | <pre> | ||
| + | set point to [<point as character>] | ||
| + | </pre> | ||
| + | |||
| + | * [[SET SEPARATOR|set separator]] - specify the character to be used to mark thousands | ||
| + | |||
| + | <pre> | ||
| + | set separator to [<separator as character>] | ||
| + | </pre> | ||
| + | |||
| + | ===Numeric Conversion Functions=== | ||
* [[ABS()|abs()]] - return the absolute value of a numeric | * [[ABS()|abs()]] - return the absolute value of a numeric | ||
* [[CAST()|cast()]] - perform data type conversion | * [[CAST()|cast()]] - perform data type conversion | ||
| Line 18: | Line 40: | ||
===Miscellaneous Numeric Functions=== | ===Miscellaneous Numeric Functions=== | ||
| − | |||
| − | |||
| − | |||
| − | |||
* [[ACOS()|acos()]] - calculate the angle size in radians of a cosine | * [[ACOS()|acos()]] - calculate the angle size in radians of a cosine | ||
* [[ASIN()|asin()]] - calculate the angle size of any given sine value | * [[ASIN()|asin()]] - calculate the angle size of any given sine value | ||
| Line 49: | Line 67: | ||
===Miscellaneous Financial Functions=== | ===Miscellaneous Financial Functions=== | ||
| − | |||
| − | |||
| − | |||
| − | |||
* [[CAGR()|cagr()]] - calculate compound annual growth rate | * [[CAGR()|cagr()]] - calculate compound annual growth rate | ||
* [[FV()|fv()]] - calculate the future value of a periodic investment | * [[FV()|fv()]] - calculate the future value of a periodic investment | ||
Revision as of 17:08, 19 January 2010
Contents
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
- 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
