# 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.

`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 = TRUNCATE(2.9)` Creates
a new column named |

`TEMP = TRUNCATE(V1)` Creates
a new column named |

`TEMP = TRUNCATE(V1:V3)`
Creates three new columns named |

`TEMP = TRUNCATE(V1[10:20])`
Creates a new column named |

`TEMP = TRUNCATE(V1[50:99]:V2)`
Creates two new columns named |

## 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 |