INT macro

The INT macro is available only in HCL® Campaign.

Syntax

INT(data)

Parameters

data

The numerical values to round down to an integer value. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your HCL product.

Description

INT calculates the greatest integer less than the values (also known as the floor) in the specified data range. INT returns one new column for each input column, each containing the floor of numbers in the corresponding input column.

Note: This is the same as the FLOOR macro function.

Examples


`TEMP = INT(4.7)` Creates a new column named `TEMP` containing the value `4`.
`TEMP = INT(-1.5)` Creates a new column named `TEMP` containing the value `-2`.
`TEMP = INT(V1)` Creates a new column named `TEMP`, where each value is the largest integer less than or equal to the contents of column `V1`.
`TEMP = V1 - INT(V1)` Creates a new column named `TEMP` containing the decimal portion of each value in column `V1`.
`TEMP = INT(V1:V3)` Creates three new columns named `TEMP`, `VX`, and `VY`. The values in the `TEMP` column are the largest integers less than or equal to the contents of column `V1`, the values of the `VX` column are the largest integers less than or equal to the contents of column `V2`, and the values of the `VY` column are the largest integers less than or equal to the contents of column `V3`.
`TEMP = INT(V1[10:20])` Creates a new column named `TEMP`, where the first 11 cells contain the largest integers less than or equal to the corresponding values in rows 10-20 of column `V1`. The other cells in `TEMP` are empty.
`TEMP = INT(V1[1:5]:V2)` Creates two new columns named `TEMP` and `VX`, each with values in rows 1-5 (the other cells are empty). The values in column `TEMP` are the largest integers less than or equal to the corresponding row values of column `V1`, and the values in column `VX` are the largest integers less than or equal to the corresponding row values of column `V2`.

Related functions


Function	Description
`ROUND`	Computes the rounded value of the contents of the specified data range
`TRUNCATE`	Returns the non-fractional part of each value in the specified data range