Difference between revisions of "Working With Numeric Data in Recital"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Numeric Conversion Functions) |
Yvonnemilne (Talk | contribs) (→Miscellaneous Numeric Functions) |
||
| Line 25: | Line 25: | ||
* [[ATN2()]] - calculate the angle size for the specified cosine and sine values of a given point | * [[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()]] - determine whether an expression is between two other specified expressions | ||
| − | * [[CEILING()]] - | + | * [[CEILING()]] - calculate the smallest integer that is greater than or equal to a given value |
* [[COS()]] - calculate the cosine of an angle in radians | * [[COS()]] - calculate the cosine of an angle in radians | ||
* [[DTOR()]] - perform degree to radian conversion | * [[DTOR()]] - perform degree to radian conversion | ||
* [[EXP()]] - calculate exponential value | * [[EXP()]] - calculate exponential value | ||
| − | * [[FLOOR()]] - | + | * [[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 | * [[LOG()]] - calculate natural logarithm value | ||
* [[LOG10()]] - calculate base 10 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 | * [[PI()]] - return the value of pi | ||
| + | * [[RAND()]] - return a random number | ||
* [[ROUND()]] - return a rounded numeric | * [[ROUND()]] - return a rounded numeric | ||
* [[RTOD()]] - perform radian to degree conversion | * [[RTOD()]] - perform radian to degree conversion | ||
* [[SIGN()]] - return the sign of a numeric value | * [[SIGN()]] - return the sign of a numeric value | ||
* [[SIN()]] - calculate the sine of an angle in radians | * [[SIN()]] - calculate the sine of an angle in radians | ||
| + | * [[SQRT()]] - calculate a square root | ||
* [[TAN()]] - calculate the tangent of an angle in radians | * [[TAN()]] - calculate the tangent of an angle in radians | ||
Revision as of 12:38, 21 October 2009
Contents
Working With Numeric Data in Recital
Numeric Conversion Functions
See Also
Table of Contents
- ABS() - return a numeric's absolute value
- CAST() - perform data type conversion
- CURRENCY() - perform numeric to currency string conversion
- ETOS() - perform expression to string conversion
- INT() - return a numeric's integer value
- 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
- CEILING() - 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
