13.12. NUMERIC

About
Functions order

13.12.1. About NUMERIC

13.12.2. NUMERIC functions order

ABS() Return the absolute value of a numeric expression
ASC() Convert a character to its ASCII value
BETWEEN() Check value.
BIN2I() Convert a 16-bit signed integer to a numeric value
BIN2L() Convert a 32-bit signed integer to a numeric value
BIN2W() Convert a 16-bit unsigned integer to a numeric value
CHR() Convert an ASCII code to a character value
DSTRTON() Convert string as "double" to xClipper-numeric.
EMPTY() Determine if the result of an expression is empty
EXP() Calculate e**x
FSTRTON() Convert string as "float" to xClipper-numeric.
FT_GCD() Calculate greatest common divisor of two numbers
FT_NETPV() Calculate net present value
FT_RAND1() Generate a random number
FT_ROUND() Rounds a number to a specific place
HASHNAME() Returns string from hash values.
HASHSTR() Returns hash code for string.
I2BIN() Convert a xClipper numeric to a 16-bit binary integer
INT() Convert a numeric value to an integer
ISDIGIT() Determine if the leftmost character in a character string is a digit
L2BIN() Convert a xClipper numeric value to a 32-bit binary integer
LEN() Return the length of a character string or the number of elements in an array
LOG() Calculate the natural logarithm of a numeric value
MAX() Return the larger of two numeric or date values
MIN() Return the smaller of two numeric or date values
MOD() Return the modulus of two numbers
QOUT() Display a list of expressions to the console
ROUND() Return a numeric value rounded to a specified number of digits
SQRT() Return the square root of a positive number
TRANSFORM() Convert any value into a formatted character string
TYPE() Determine the type of an expression
VAL() Convert a character number to numeric type
VALTYPE() Determine the data type returned by an expression

13.12.2.7. Function FT_NETPV()

 FT_NETPV( <nInitialInvestment>, <nInterestRate>, <aCashFlow> ;
 [, <nNoOfCashFlows> ] ) -> nNetPV

13.12.2.9. Function FT_ROUND()

 FT_ROUND( <nNumber> [, <nRoundToAmount>           ;
 [, <cRoundType>  [, <cRoundDirection>   ;
 [, <nAcceptableError> ] ] ] ] )            -> nNumber

13.12.2.17. Function ROUND()

 ROUND(<nNumber>, <nDecimals>) --> nRounded