ROUND macro
The ROUND
macro
is available only in Unica Campaign.
Syntax
ROUND(data)
Parameters
data
The
numerical values to round. 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
ROUND
rounds
the values in the specified data range to the nearest integer. It
returns one new column for each input column, each containing the
rounded value of numbers in the corresponding input column. Numbers
exactly halfway in-between are rounded up (for example, 2.5
is rounded to 3.0
and 2.5
is rounded
to -2.0
).
Examples
TEMP = ROUND(3.2) Creates
a new column named |
TEMP = ROUND(V1) Creates
a new column named |
TEMP = ROUND(V1:V3) Creates
three new columns named |
TEMP = ROUND(V1[10:20])
Creates a new column named |
TEMP = ROUND(V1[1:5]:V2)
Creates two new columns named |
Related functions
Function | Description |
---|---|
INT |
Computes the integer value (rounded down) of the contents of the specified data range |
MOD |
Computes the modulo of the contents of the specified data range |
TRUNCATE |
Returns the non-fractional part of each value in the specified data range |