For example, LN(3)returns 1.098612. You usually use this function to analyze scientific data rather than business data.
This function is the reciprocal of the function EXP.
Syntax
LN( numeric_value )
Argument
Required/
Optional
Description
numeric_value
Required
Numeric datatype. It must be a positive number, greater than 0. Passes the values for which you want to calculate the natural logarithm. You can enter any valid expression.
Return Value
Double value.
NULL if a value passed to the function is NULL.
Example
The following expression returns the natural logarithm for all values in the NUMBERS column:
LN( NUMBERS )
NUMBERS
RETURN VALUE
10
2.302585092994
125
4.828313737302
0.96
-0.04082199452026
NULL
NULL
-90
None. (Data Integration writes the row to the error rows file.)
0
None. (Data Integration writes the row to the error rows file.)
Note: When you pass a negative number or 0, Data Integration writes the row into the error rows file. The numeric_value must be a positive number greater than 0.