Computes the natural logarithm of an input value. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.

Numeric literal example:

derive type:single value: LN(10)

Output: Generates a column containing the value X, such that e x, is 10. This value is approximately 2.302585092994046.

Column reference example:

derive type:single value: LN(MyValue) as: 'ln_MyValue'

Output: Generates the new ln_MyValue column containing the power to which e is raised to yield the value in the MyValue column.

derive type:single value: LN(numeric_value)

ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal to apply to the function

numeric_value

Name of the column or numeric literal, the natural logarithm of which is to be computed.

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal10

Example - Exponential Functions