NOT macro
The NOT
macro
is available in Unica Campaign and Unica Interact.
Syntax
NOT(data) ! data
Parameters
data
The
numerical values to compute the logical NOT 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
NOT
returns
the logical NOT of the values in the specified data range. It returns
one new column for each input column, each containing the logical
NOT of the values in the corresponding input column. This function
returns zero for non-zero values and one for zero values.
NOT
operator can be abbreviated with
an exclamation mark (!
). Use the exclamation mark
before the data value (for example, to specify NOT(V1)
,
you can simply type !V1
).Examples
TEMP = NOT(3.2) or TEMP = !1
Creates a new column named |
TEMP = !0 or TEMP = !(2+2=3)
Creates a new column named |
TEMP = !V1 Creates
a new column named |
TEMP = !V1:V3 Creates
three new columns named |
TEMP = !V1[10:20] Creates
a new column named |
TEMP = !V1[1:5]:V2 Creates
two new columns named |
Related functions
Function | Description |
---|---|
AND |
Computes the logical AND between two specified data ranges |
INVERSE |
Computes the negative of the contents of the specified data range |
OR |
Computes the logical OR between two specified data ranges |
SIGN |
Computes the sign (positive or negative) of the values in the specified data range |