LN
Returns the natural logarithm of a numeric value. 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. (Informatica Cloud writes the row to the error rows file.) |
0 | None. (Informatica Cloud writes the row to the error rows file.) |
Note: When you pass a negative number or 0, Informatica Cloud writes the row into the error rows file. The numeric_value must be a positive number greater than 0.