LN
LN('Node')
The LN function returns the natural logarithm of a number (logarithm with base e ~2.718), while retaining all dimensions.
Use this function when you need a natural logarithm transformation for positive numeric values.
Parameters
- NodeNode referenceRequired
- Input node, specified using the node name in single quotes (e.g.
'Profit')
Example
Natural logarithm of integer and decimal values
This example shows the natural logarithm computed for a node with integer and decimal values.
Input node: 'A'
| Year | Value |
|---|---|
| 2025 | 2 |
| 2026 | 3 |
| 2027 | 4.5 |
Formula: LN('A')
| Year | LN Result |
|---|---|
| 2025 | 0.69 |
| 2026 | 1.10 |
| 2027 | 1.50 |