LN or LOG macro
The LN
or LOG
macro
is available only in Unica Campaign.
Syntax
LN(data)
or LOG(data)
Parameters
data
The
numerical values to compute the natural logarithm 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
LN
or LOG
calculates the natural log of each value in the specified data range.
It returns one new column for each input column, each containing the
natural logarithm of numbers in the corresponding input column. Natural
logarithms are based on the constant e = 2.7182818. LN
is the inverse of the EXP
macro function.
Examples
TEMP = LN(3) or TEMP = LOG(3)
Creates a new column named |
TEMP = LN(V1) Creates
a new column named |
TEMP = LN(V1:V3) Creates
three new columns named |
TEMP = LN(V1[10:20]) Creates
a new column named |
TEMP = LN(V1[1:5]:V2)
Creates two new columns named |
Related functions
Function | Description |
---|---|
EXP |
Computes the natural number (e) raised to the contents of each cell in the specified data range |
LOG2 |
Computes the log base2 of the contents of the specified data range |
LOG10 |
Computes the log base10 of the contents of the specified data range |
POW |
Computes a base value raised to the specified exponential power(s) |