Difference between revisions of "Working With Numeric Data in Recital"

Revision as of 13:48, 22 January 2010

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

numeric = abs(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

Miscellaneous Financial Functions

• 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