Essbase @LN

Returns the natural logarithm (base e)
of the specified expression.

Syntax

@LN (expression)
Parameter Description
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

See Also

  • @LOG10
  • @LOG
  • @EXP