Working With Numeric Data in Recital

From Recital Documentation Wiki
Revision as of 12:42, 21 October 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

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
  • 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

Summary