Truncate

Description

Truncates a number to the specified number of decimal places.

Syntax

Truncate ( x, n )

Argument

Description

x

The number you want to truncate

n

The number of decimal places to which you want to truncate x (valid values are 0 through 18)

Returns

Decimal. Returns the result of the truncation if it succeeds and null if it fails or if any argument is null.

NoteUsing Truncate on a computed field A real number loaded into a floating point register (used for calculation) is represented as precisely as the binary storage will permit. For example, the real number displayed as 2.07 is actually stored as 2.0699999999999997.

Truncating such a number may not give the expected result. To avoid this problem, you can change the initial real datatype to long, Integer, or decimal, or you can append a constant in the truncate argument: Truncate (x + 0.0000001, n )

Examples

Example 1

This statement returns 9.2:

Truncate(9.22, 1)

Example 2

This statement returns 9.2:

Truncate(9.28, 1)

Example 3

This statement returns 9:

Truncate(9.9, 0)

Example 4

This statement returns –9.2:

Truncate(-9.29, 1)

See also