HotDocs Author WorkflowCreate a template Add placeholders Group variables in dialogs Upload a template Create a script

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