INT in TM1: Finding the Largest Integer Less Than or Equal To a Specified Value

The INT function allows you to return the nearest integer less than or equal to a specified value.

Syntax of INT

The syntax of the INT function is simply:

INT ( value);

where:

• value is the number you are assessing

Example

An example is

INT (11.6);

This will return 11.

An example of a negative number is

INT (-11.6);

This will return -12.

Notes about INT

INT can be used in both TI’s and Rules.

It works identically to the same function in Excel.