@LN

The @LN calculation function for Essbase returns the natural logarithm (base e) of the specified expression.

Syntax

@LN (expression)

Parameters

expression: Single member specification, member combination, or other numeric expression. If less than or equal to 0, Essbase returns #MISSING.

Example

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

LN_Sales = @LN(Sales);

This example produces the following result:

                                   Cola East
               Jan       Feb       Mar           Nov      Dec
Sales          100       110       120 . . .       0      210
LN_Sales   4.65052   4.70048   4.78749 . . . #MISSING  5.34710