SIGN macro

The SIGN macro is available only in HCL® Campaign.

Syntax

SIGN(data)

Parameters

data

The numerical values to compute the sign 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 HCL product.

Description

SIGN tests the sign of the values in the specified data range. It returns one new column for each input column, each containing the sign of numbers in the corresponding input column. Positive one is returned for all values greater than zero; negative one is returned for all values less than zero; zero is returned for values of zero.

Examples


`TEMP = SIGN(-3)` Creates a new column named `TEMP` containing the value `-1`.
`TEMP = SIGN(V1)` Creates a new column named `TEMP`, where each value is the sign of the contents of column `V1`.
`TEMP = SIGN(V1:V3)` Creates three new columns named `TEMP`, `VX`, and `VY`. The values in the `TEMP` column are the signs of the contents of column `V1`, the values of the `VX` column are the signs of the contents of column `V2`, and the values of the `VY` column are the signs of the contents of column `V3`.
`TEMP = SIGN(V1[10:20])` Creates a new column named `TEMP`, where the first 11 cells contain the signs of the values in rows 10-20 of column `V1`. The other cells in `TEMP` are empty.
`TEMP = SIGN(V1[10:50]:V2)` Creates two new columns named `TEMP` and `VX`, each with values in rows 1-41 (the other cells are empty). The values in column `TEMP` are the signs of the values in rows 10-50 of column `V1`, and the values in column `VX` are the signs of the values in rows 10-50 of column `V2`.

Related Functions


Function	Description
`ABS`	Computes the absolute value of the contents of the specified data range
`INVERSE`	Computes the negative of the contents of the specified data range