TRUNCATE Function

The TRUNCATE function trims and returns (without rounding) the number value you specify at the number of decimal points you specify.

TRUNCATE is also used to evaluate whether a specific amount or if any decimal places exist at all (See example below). The difference between the TRUNCATE function and the ROUND function is that TRUNCATE simply "cuts off" a number at a specified digit, while ROUND actually rounds a number up or down, based on where you want the number rounded.

Function name	TRUNCATE
Usage model	TRUNCATE ( VAR, NUM )
Parameters	This function requires you to replace two parameters:
VAR	The function shortens this number value by a certain amount of places after the decimal point.
NUM	The function shortens VAR by this specified value.
Result	A number value.

Example

You can truncate a decimal number a specified number of places after a decimal point.

For example, the following script truncates the number 5.9375 to include only the first two digits after the decimal point. The truncated value is 5.93:

SET NumberVar TO TRUNCATE ( 5.9375, 2 )

In the next example, however, a Computation tests if the value of Rent Amount includes cents. The variable is then formatted to eliminate the text AND NO CENTS from being merged when the variable contains only a whole number:

IF Rent Amount = TRUNCATE( Rent Amount, 0 )
    FORMAT( Rent Amount, "NINE DOLLARS" )
ELSE
    FORMAT( Rent Amount, "NINE DOLLARS AND TWELVE CENTS" )
END IF

Download

After you download the example template, you can import the template to any workspace to see this example code in action.