Format the number fields
ABS
This function returns the absolute value of the input result. The returned value is always positive.
Example
ABS(-4) = 4
CEILING
This function returns the smallest integer greater than or equal to value of the input result.
Example
CEILING(1.3) = 2
CONVERTNUMBER
This function changes a text or boolean field to a numeric or currency field.
Example
ConvertNumber('12.5', 1) = 12.5
FLOOR
This function returns the largest integer less than or equal to value of the input.
Example
FLOOR(1.8) = 1
ROUND
This function returns the value of a number rounded to a defined number of decimals.
Example
ROUND(3.512,2) = 3.51
TRUNCATE
This function returns the number without the decimal(s).
Example
TRUNCATE(-3.56) = -3
SIGN
This function returns the sign of a number, indicating whether the number is positive, negative or zero.
Example
SIGN(-3) = -1
SIGN(3) = 1
SIGN(0) = 0