Essbase Mathematical Functions

These functions perform specific mathematical calculations. Mathematical
functions define and return values that are based on selected member expressions.
These functions cover many basic statistical functions and return numeric
results that are based on supplied member values. Advanced statistical functions
are included in the statistical functions category.

In the following quick-reference table, words in italics loosely represent
information you supply to the function. For details, see the individual function
topics.

Function Return Value
@ABS Absolute value of expression.
@AVG Average of all values in expList.
@EXP e (base of natural logarithms) raised to the power of expression.
@FACTORIAL Factorial of expression.
@INT Next lowest integer value of expression.
@LN e (base of natural logarithms) of expression.
@LOG Any base logarithm of expression.
@LOG10 Base-10 logarithm of expression.
@MAX Maximum value found in cells of expression
list
.
@MAXS Maximum value found in cells of expression
list
, optionally skipping empty values.
@MIN Minimum value found in cells of expression
list
.
@MINS Minimum value found in cells of expression
list
, optionally skipping empty values.
@MOD Modulus of a division operation between two members.
@POWER Expression raised to power.
@REMAINDER Remainder value of expression.
@ROUND Expression rounded to numDigits.
@SUM Sum of values found in cells of expression
list
.
@TRUNCATE Expression with fractional part
removed, returning an integer.
@VAR Variance between two members.
@VARPER Percent variance between two members.