TRUNCATE macro

The TRUNCATE macro is available only in Unica Campaign.

Syntax

TRUNCATE(data)

Parameters

data

The numerical values to truncate. 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

TRUNCATE calculates the whole part of each value in the specified data range. It returns one new column for each input column, each containing the whole number (non-fractional) part of the numbers in the corresponding input column.

Note: The FRACTION macro function and the TRUNCATE macro function are complementary in that they sum to the original values.

Examples

TEMP = TRUNCATE(4.3)

Creates a new column named TEMP containing the value 4.
TEMP = TRUNCATE(2.9)

Creates a new column named TEMP containing the value -2.
TEMP = TRUNCATE(V1)

Creates a new column named TEMP, where each value is the fractional part of the contents of column V1.
TEMP = TRUNCATE(V1:V3)

Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the truncated parts of column V1, the values of the VX column are the truncated parts of column V2, and the values of the VY column are the truncated parts of column V3.
TEMP = TRUNCATE(V1[10:20])

Creates a new column named TEMP, where the first 11 cells contain the truncated parts of the values in rows 10-20 of column V1. The other cells in TEMP are empty.
TEMP = TRUNCATE(V1[50:99]:V2)

Creates two new columns named TEMP and VX, each with values in rows 1-50 (the other cells are empty). The values in column TEMP are the truncated parts of the rows of column V1, and the values in column VX are the truncated parts of the values in column V2.

Related functions

Function Description
CEILING Computes the ceiling of each value in the specified data range
FLOOR Computes the floor of each value in the specified data range
FRACTION Returns the fractional part of each value in the specified data range