Number¶

number\format
number\abs
number\power
number\round
number\floor
number\ceil
number\randomInt
number\parseInt
number\parseFloat

number\format¶

number\format(VALUE, [DECIMALS], [DECIMAL_MARK], [THOUSAND_SEPARATOR])

Converts numeric VALUE into string formatted according to a specific format or default application settings. If DECIMALS, DECIMAL_MARK or THOUSAND_SEPARATOR are omitted, then system defaults are used.

Example

number\format(2.666667, 2) – results 2.67;

number\format(1000, 2) – results 1,000.00;

number\format(10.1, 0) – results 10.

number\abs¶

number\abs(VALUE)

Absolute value. Returns null if VALUE is not numeric.

number\power¶

number\power(VALUE, EXP)

Raising VALUE to EXP. VALUE and EXP should be int or float. Returns int or float. (as of v8.2)

number\round¶

number\round(VALUE, PRECISION)

Returns the rounded value of VALUE to specified PRECISION (number of digits after the decimal point). PRECISION can also be negative or zero (default).

number\floor¶

number\floor(VALUE)

Returns the next lowest integer value by rounding down value if necessary.

number\ceil¶

number\ceil(VALUE)

Returns the next highest integer value by rounding up value if necessary.

number\randomInt¶

number\randomInt([MIN, MAX])

Generates a cryptographic random integer between specified MIN and MAX. If MIN is omitted, then 0 is used.

number\parseInt¶

number\parseInt(STRING)

Converts a string to an integer number. (as of v7.1)

number\parseFloat¶

number\parseFloat(STRING)

Converts a string to a float number. (as of v7.1)