Math
Return a rounded number.
ROUND(value: float)
roundedValue: float
ROUND(1.45)
Return value:
1
Returns the rounded-down number.
FLOOR(value: float)
roundedValue: float
FLOOR(1.45)
Return value:
1
Returns the rounded-up number.
FLOOR(value: float)
roundedValue: float
CEIL(1.45)
Return value:
2
Returns the number added to specified decimals.
TO_FIXED(value: float, decimals: integer)
roundedValue: float
TO_FIXED(123,3)
Return value:
123.000
Returns a minimal numeric value from a series.
MIN(value: array)
minimalValue: float
MIN(11, 79, 82)
Return value:
11
Returns a maximal numeric value from a series.
MAX(value: array)
maximalValue: float
MAX(11, 79, 82)
Return value:
82
Returns a formatted number with specified decimal places, delimiter, and decimal point.
FORMAT_NUMBER(number: float, decimals: integer, delimiter: string, decimalPoint: string)
formattedNumber: string
FORMAT_NUMBER(12346734.12, 4, ".", ",")
Return value:
"12.346.734,1200"
Last modified 1yr ago