INVERSE macro

The INVERSE macro is available only in Unica Campaign.

Syntax

INVERSE(data)

Parameters

data

The numerical values to compute the inverse 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

INVERSE calculates the negative of the values in the specified data range. It returns -x (that is, negative values are returned as positive values, and positive values are returned as negative values). INVERSE returns one new column for each input column, each containing the inverse of the values in the corresponding input column.

Note: To invert a value or a column, precede it with a minus sign (-). For example, V2 = -V1 is the same as V2 = INVERSE(V1).

Examples

TEMP = INVERSE(3.2)

Creates a new column named TEMP containing the value -3.2.

TEMP = INVERSE(V1)

Creates a new column named TEMP, where each value is the negative of the values in column V1.

TEMP = INVERSE(V1:V3)

Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the negatives of values in column V1, the values of the VX column are the negatives of the values in column V2, and the values of the VY column are the negatives of the values in column V3.

TEMP = INVERSE(V1[10:20])

Creates a new column named TEMP, where the first 11 cells contain the negatives of the values of the values in rows 10-20 of column V1. The other cells in TEMP are empty.

TEMP = INVERSE(V1[1:5]:V2)

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

Related functions

Function Description
ABS Computes the absolute value of the contents of the specified data range
NOT Computes the logical NOT of the contents of the specified data range
SIGN Computes the sign (positive or negative) of the values in the specified data range