Returns the exponent of an expression; that is, the value of e (the base of natural logarithms) raised to the power of the expression.
Syntax
Exp ( numeric_value_expression )
Parameter | Description |
---|---|
numeric_value_expression | A numeric value (see MDX Grammar Rules). |
Notes
Exp returns the inverse of Ln, the natural logarithm.
The constant e is the base of the natural logarithm. e is approximately 2.71828182845904.
Example
The calculated member Index is created to represent e raised to the power of [Variance %]/100. In the example, [Variance %] divided by 100 is the numeric value expression provided to the Exp function.
WITH MEMBER [Scenario].[Index] AS 'Exp( [Scenario].[Variance %]/100 )' SELECT {[Scenario].[Variance %], [Scenario].[Index]} ON COLUMNS, {[Market].children} ON ROWS FROM Sample.Basic WHERE {[Sales]}
This query returns the grid:
(axis) | Variance % | Index |
---|---|---|
East | 10.700 | 1.113 |
West | 10.914 | 1.115 |
South | 3.556 | 1.036 |
Central | 3.595 | 1.037 |
See Also