@EXP

The @EXP calculation function for Essbase returns the exponent of a numeric expression.

This function returns the exponent of a specified expression; that is, the value of e (the base of natural logarithms) raised to the power of the specified expression.

Syntax

@EXP (expression)

Parameters

expression: Single member specification, variable name, function, or other numeric expression. If less than -700 or greater than 700, Essbase returns #MISSING.

Example

The following example is based on a variation of Sample Basic:

Index = @EXP("Variance %"/100);

This example produces the following result:

                    East      West     South   Central  
Variance %       10.7      10.9       3.6       3.6    
Index         1.11293   1.11516   1.03666   1.03666