Working With Numeric Data in Recital

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
• 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() - return 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() - return the largest integer that is less than or equal to a given number
• LOG() - calculate natural logarithm value
• LOG10() - calculate base 10 logarithm value
• PI() - return the value of pi
• 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
• 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