Numbers

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 (based on the second parameter).

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