TRIM Function

Truncates decimal places.

The TRIM 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 -13, removing the value after the decimal.

TRIM(-13.6)