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 95: | Line 95: | ||
===Miscellaneous Numeric Functions=== | ===Miscellaneous Numeric Functions=== | ||
* [[ACOS()|acos()]] - calculate the angle size in radians of a cosine | * [[ACOS()|acos()]] - calculate the angle size in radians of a cosine | ||
| + | |||
| + | <pre> | ||
| + | numeric = acos(cosine as numeric) | ||
| + | </pre> | ||
| + | |||
* [[ASIN()|asin()]] - calculate the angle size of any given sine value | * [[ASIN()|asin()]] - calculate the angle size of any given sine value | ||
| + | |||
| + | <pre> | ||
| + | numeric = asin(sine as numeric) | ||
| + | </pre> | ||
| + | |||
* [[ATAN()|atan()]] - calulate the angle size of a given tangent value | * [[ATAN()|atan()]] - calulate the angle size of a given tangent value | ||
| + | |||
| + | <pre> | ||
| + | numeric = atan(tangent as numeric) | ||
| + | </pre> | ||
| + | |||
* [[ATN2()|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 | ||
| + | |||
| + | <pre> | ||
| + | numeric = atn2(cosine as numeric, sine as numeric) | ||
| + | </pre> | ||
| + | |||
* [[BETWEEN()|between()]] - determine whether an expression is between two other specified expressions | * [[BETWEEN()|between()]] - determine whether an expression is between two other specified expressions | ||
* [[CEILING()|celing()]] - 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()|cos()]] - calculate the cosine of an angle in radians | * [[COS()|cos()]] - calculate the cosine of an angle in radians | ||
| + | |||
| + | <pre> | ||
| + | numeric = cos(radians as numeric) | ||
| + | </pre> | ||
| + | |||
* [[DTOR()|dtor()]] - perform degree to radian conversion | * [[DTOR()|dtor()]] - perform degree to radian conversion | ||
| + | |||
| + | <pre> | ||
| + | numeric = dtor(degrees as numeric) | ||
| + | </pre> | ||
| + | |||
* [[EXP()|exp()]] - calculate exponential value | * [[EXP()|exp()]] - calculate exponential value | ||
* [[FLOOR()|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 | ||
| Line 114: | Line 144: | ||
* [[RAND()|rand()]] - return a random number | * [[RAND()|rand()]] - return a random number | ||
* [[ROUND()|round()]] - return a rounded numeric | * [[ROUND()|round()]] - return a rounded numeric | ||
| + | |||
| + | <pre> | ||
| + | numeric = round(number as numeric) | ||
| + | </pre> | ||
| + | |||
* [[RTOD()|rtod()]] - perform radian to degree conversion | * [[RTOD()|rtod()]] - perform radian to degree conversion | ||
| + | |||
| + | <pre> | ||
| + | numeric = rtod(radians as numeric) | ||
| + | </pre> | ||
| + | |||
* [[SIGN()|sign()]] - return the sign of a numeric value | * [[SIGN()|sign()]] - return the sign of a numeric value | ||
| + | |||
| + | <pre> | ||
| + | numeric = sign(number as numeric) | ||
| + | </pre> | ||
| + | |||
* [[SIN()|sin()]] - calculate the sine of an angle in radians | * [[SIN()|sin()]] - calculate the sine of an angle in radians | ||
| + | |||
| + | <pre> | ||
| + | numeric = sin(radians as numeric) | ||
| + | </pre> | ||
| + | |||
* [[SQRT()|sqrt()]] - calculate a square root | * [[SQRT()|sqrt()]] - calculate a square root | ||
| + | |||
| + | <pre> | ||
| + | numeric = sqrt(number as numeric) | ||
| + | </pre> | ||
| + | |||
* [[TAN()|tan()]] - calculate the tangent of an angle in radians | * [[TAN()|tan()]] - calculate the tangent of an angle in radians | ||
| + | |||
| + | <pre> | ||
| + | numeric = tan(radians as numeric) | ||
| + | </pre> | ||
===Miscellaneous Financial Functions=== | ===Miscellaneous Financial Functions=== | ||
Revision as of 14:37, 22 January 2010
Contents
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(number as numeric)
- cast() - perform data type conversion
expression = cast(expression as expression AS datatype as character [, width as numeric [, precision as numeric]] [null | not null])
- chr() - perform numeric to ASCII character conversion
character = chr(number as numeric)
- ctrl() - return the numeric value of a control character
numeric = ctrl(letter as character)
- currency() - perform numeric to currency string conversion
character = currency(number as numeric)
- etos() - perform expression to string conversion
character = etos(expression as expression)
- int() - return the integer value of a numeric
numeric = int(number as numeric)
- str() - perform numeric to string conversion
character = str(number as numeric [, width as numeric [, decimals as numeric [, base as numeric]]] )
- strzero() - perform numeric to zero left-padded string conversion
character = strzero(number as numeric [, width as numeric [, decimals as numeric]])
- transform() - perform expression to string conversion based on a picture formatting clause
character = transform(expression as expression, picture as character)
- val() - perform string to numeric conversion
numeric = val(string as character)
Miscellaneous Numeric Functions
- acos() - calculate the angle size in radians of a cosine
numeric = acos(cosine as numeric)
- asin() - calculate the angle size of any given sine value
numeric = asin(sine as numeric)
- atan() - calulate the angle size of a given tangent value
numeric = atan(tangent as numeric)
- atn2() - calculate the angle size for the specified cosine and sine values of a given point
numeric = atn2(cosine as numeric, sine as numeric)
- 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
numeric = cos(radians as numeric)
- dtor() - perform degree to radian conversion
numeric = dtor(degrees as numeric)
- 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
numeric = round(number as numeric)
- rtod() - perform radian to degree conversion
numeric = rtod(radians as numeric)
- sign() - return the sign of a numeric value
numeric = sign(number as numeric)
- sin() - calculate the sine of an angle in radians
numeric = sin(radians as numeric)
- sqrt() - calculate a square root
numeric = sqrt(number as numeric)
- tan() - calculate the tangent of an angle in radians
numeric = tan(radians as numeric)
