Returns the result of a logarithm calculation where you can specify both the base to use and the expression to calculate.
@LOG (expression [, base])
expression | Single member specification, variable name, function, or other numeric
expression. If less than or equal to 0, Analytic Services returns #MISSING .
|
base | Optional. Single member specification, member combination, or numeric
expression.
|
The @LOG function returns the logarithm of expression calculated using the specified base. @LOG (x,b) is equivalent to logb(x).
The following example is based on a variation of Sample Basic:
LOG2_Sales = @LOG(Sales,2);
This example produces the following result:
Cola East Jan Feb Mar Nov Dec Sales 100#MISSING
120 . . . 0 210 LOG2_Sales 6.64386#MISSING
6.90689 . . .#MISSING
7.71425
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |