# FRACTION macro

The `FRACTION` macro is available only in Unica Campaign.

## Syntax

`FRACTION(data)`

## Parameters

`data`

The numerical values to compute the fraction of. 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

`FRACTION` calculates the fractional part of the values in the specified data range. It returns one new column for each input column, each containing the 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 = FRACTION(4.3)` Creates a new column named `TEMP` containing the value `0.3`. `TEMP = FRACTION(2.9)` Creates a new column named `TEMP` containing the value `-0.9`. `TEMP = FRACTION(V1)` Creates a new column named `TEMP`, where each value is the fractional part of the contents of column `V1`. `TEMP = FRACTION(V1:V3)` Creates three new columns named `TEMP`, `VX`, and `VY`. The values in the `TEMP` column are the fractional parts of the contents of column `V1`, the values of the `VX` column are the fractional parts of the contents of column `V2`, and the values of the `VY` column are the fractional parts of the contents of column `V3`. `TEMP = FRACTION(V1[10:20])` Creates a new column named `TEMP`, where the first 11 cells contain the fractional parts of the values in rows 10-20 of column `V1`. The other cells in `TEMP` are empty. TEMP = FRACTION(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 fractional parts of the rows of column `V1`, and the values in column `VX` are the fractional 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
`TRUNCATE` Returns the non-fractional part of each value in the specified data range