Difference between revisions of "Working With Numeric Data in Recital"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Numeric Conversion Functions) |
Yvonnemilne (Talk | contribs) (→Working With Numeric Data in Recital) |
||
| Line 5: | Line 5: | ||
'''Table of Contents''' | '''Table of Contents''' | ||
| − | * [[ABS()]] - return the absolute value of a numeric | + | * [[ABS()|abs()]] - return the absolute value of a numeric |
| − | * [[CAST()]] - perform data type conversion | + | * [[CAST()|cast()]] - perform data type conversion |
| − | * [[CHR()]] - perform numeric to ASCII character conversion | + | * [[CHR()|chr()]] - perform numeric to ASCII character conversion |
| − | * [[CTRL()]] - return the numeric value of a control character | + | * [[CTRL()|ctrl()]] - return the numeric value of a control character |
| − | * [[CURRENCY()]] - perform numeric to currency string conversion | + | * [[CURRENCY()|currency()]] - perform numeric to currency string conversion |
| − | * [[ETOS()]] - perform expression to string conversion | + | * [[ETOS()|etos()]] - perform expression to string conversion |
| − | * [[INT()]] - return the integer value of a numeric | + | * [[INT()|int()]] - return the integer value of a numeric |
| − | * [[STR()]] - perform numeric to string conversion | + | * [[STR()|str()]] - perform numeric to string conversion |
| − | * [[STRZERO()]] - perform numeric to zero left-padded string conversion | + | * [[STRZERO()|strzero()]] - perform numeric to zero left-padded string conversion |
| − | * [[TRANSFORM()]] - perform expression to string conversion based on a picture formatting clause | + | * [[TRANSFORM()|transform()]] - perform expression to string conversion based on a picture formatting clause |
| − | * [[VAL()]] - perform string to numeric conversion | + | * [[VAL()|val()]] - perform string to numeric conversion |
===Miscellaneous Numeric Functions=== | ===Miscellaneous Numeric Functions=== | ||
| Line 22: | Line 22: | ||
'''Table of Contents''' | '''Table of Contents''' | ||
| − | * [[ACOS()]] - calculate the angle size in radians of a cosine | + | * [[ACOS()|acos()]] - calculate the angle size in radians of a cosine |
| − | * [[ASIN()]] - calculate the angle size of any given sine value | + | * [[ASIN()|asin()]] - calculate the angle size of any given sine value |
| − | * [[ATAN()]] - calulate the angle size of a given tangent value | + | * [[ATAN()|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 | + | * [[ATN2()|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 | + | * [[BETWEEN()|between()]] - determine whether an expression is between two other specified expressions |
| − | * [[CEILING()]] - calculate the smallest integer that is greater than or equal to a given value | + | * [[CEILING()|celing()]] - calculate the smallest integer that is greater than or equal to a given value |
| − | * [[COS()]] - calculate the cosine of an angle in radians | + | * [[COS()|cos()]] - calculate the cosine of an angle in radians |
| − | * [[DTOR()]] - perform degree to radian conversion | + | * [[DTOR()|dtor()]] - perform degree to radian conversion |
| − | * [[EXP()]] - calculate exponential value | + | * [[EXP()|exp()]] - calculate exponential value |
| − | * [[FLOOR()]] - calculate the largest integer that is less than or equal to a given number | + | * [[FLOOR()|floor()]] - calculate the largest integer that is less than or equal to a given number |
| − | * [[LENNUM()]] - calculate the length of a numeric value | + | * [[LENNUM()|lennum()]] - calculate the length of a numeric value |
| − | * [[LOG()]] - calculate natural logarithm value | + | * [[LOG()|log()]] - calculate natural logarithm value |
| − | * [[LOG10()]] - calculate base 10 logarithm value | + | * [[LOG10()|log10()]] - calculate base 10 logarithm value |
| − | * [[MAX()]] - calculate the greater of two values | + | * [[MAX()|max()]] - calculate the greater of two values |
| − | * [[MIN()]] - calculate the lesser of two values | + | * [[MIN()|min()]] - calculate the lesser of two values |
| − | * [[MOD()]] - calculate the division remainder | + | * [[MOD()|mod()]] - calculate the division remainder |
| − | * [[PERCENT()]] - calculate percentage | + | * [[PERCENT()|percent()]] - calculate percentage |
| − | * [[PI()]] - return the value of pi | + | * [[PI()|pi()]] - return the value of pi |
| − | * [[RAND()]] - return a random number | + | * [[RAND()|rand()]] - return a random number |
| − | * [[ROUND()]] - return a rounded numeric | + | * [[ROUND()|round()]] - return a rounded numeric |
| − | * [[RTOD()]] - perform radian to degree conversion | + | * [[RTOD()|rtod()]] - perform radian to degree conversion |
| − | * [[SIGN()]] - return the sign of a numeric value | + | * [[SIGN()|sign()]] - return the sign of a numeric value |
| − | * [[SIN()]] - calculate the sine of an angle in radians | + | * [[SIN()|sin()]] - calculate the sine of an angle in radians |
| − | * [[SQRT()]] - calculate a square root | + | * [[SQRT()|sqrt()]] - calculate a square root |
| − | * [[TAN()]] - calculate the tangent of an angle in radians | + | * [[TAN()|tan()]] - calculate the tangent of an angle in radians |
===Miscellaneous Financial Functions=== | ===Miscellaneous Financial Functions=== | ||
| Line 53: | Line 53: | ||
'''Table of Contents''' | '''Table of Contents''' | ||
| − | * [[CAGR()]] - calculate compound annual growth rate | + | * [[CAGR()|cagr()]] - calculate compound annual growth rate |
| − | * [[FV()]] - calculate the future value of a periodic investment | + | * [[FV()|fv()]] - calculate the future value of a periodic investment |
| − | * [[PAYMENT()]] - calculate the payment on a loan | + | * [[PAYMENT()|payment()]] - calculate the payment on a loan |
| − | * [[PMT()]] - calculate the payment on a loan | + | * [[PMT()|pmt()]] - calculate the payment on a loan |
| − | * [[PV()]] - calculate the present value of equal regular payments on a loan | + | * [[PV()|pv()]] - calculate the present value of equal regular payments on a loan |
===Summary=== | ===Summary=== | ||
Revision as of 11:00, 23 October 2009
Contents
Working With Numeric Data in Recital
Numeric Conversion Functions
See Also
Table of Contents
- 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
See Also
Table of Contents
- 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
See Also
Table of Contents
- 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
