INT macro
The INT
macro
is available only in Unica 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 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.
FLOOR
macro function.Examples
TEMP = INT(4.7) Creates
a new column named |
TEMP = INT(-1.5) Creates
a new column named |
TEMP = INT(V1) Creates
a new column named |
TEMP = V1 - INT(V1) Creates
a new column named |
TEMP = INT(V1:V3) Creates
three new columns named |
TEMP = INT(V1[10:20])
Creates a new column named |
TEMP = INT(V1[1:5]:V2)
Creates two new columns named |
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 |