Mathematical Functions

Mathematical calculation functions in Essbase perform calculations such as average, minimum, maximum, sum, exponent, logarithm, round, variance, and other basic statistical methods. These functions return numeric results for input member value expressions that you supply.

These functions cover many basic statistical functions. More 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.

Table 3-7 Mathematical Functions

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 an expression list.
@MAXS	Maximum value found in cells of an expression list, optionally skipping empty values.
@MIN	Minimum value found in cells of expression list.
@MINS	Minimum value found in cells of an 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 an expression list.
@TRUNCATE	Expression with fractional part removed, returning an integer.
@VAR	Variance between two members.
@VARPER	Percent variance between two members.