Skip to content
English
  • There are no suggestions because the search field is empty.

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