TRIM (TRUNC) Function

Truncates decimal places.

The TRIM or TRUNC calculation function truncates any decimal places of the parameter value which is sourced to the function.

Command Syntax:

TRIM([parameter1])

EXAMPLE:

This formula sets a line value to 13, removing the value after the decimal.

TRIM(13.6)

EXAMPLE:

This formula sets a line value to -15, removing the value after the decimal.

TRIM(-15.3)

Note: Beginning with Prospero version 2.1.1095, the term TRUNC can be used interchangeably with TRIM. The two terms are functionally identical within Prospero.