Returns the natural logarithm (base e) of an expression.
Syntax
Ln ( numeric_value_expression )
Parameter | Description |
---|---|
numeric_value_expression | A numeric value (see MDX Grammar Rules). |
Notes
Ln returns the inverse of Exp.
The constant e is the base of the natural logarithm. e is approximately 2.71828182845904.
Example
WITH MEMBER [Measures].[Ln_Sales] AS 'Ln([Measures].[Sales])' SELECT {[Year].levels(0).members} ON COLUMNS, {[Measures].[Sales], [Measures].[Ln_Sales]} ON ROWS FROM Sample.Basic WHERE ([Market].[East], [Product].[Cola])
returns the following grid:
(axis) | Jan | Feb | ... | Nov | Dec |
---|---|---|---|---|---|
Sales | 1812 | 1754 | ... | 1708 | 1841 |
Ln_Sales | 7.502 | 7.470 | ... | 7.443 | 7.518 |
See Also