Mathematical Operations

Essbase mathematical functions in the calculation language allow you to perform a variety of operations using numerical expression in formulas.

Table 18-4 List of Mathematical Functions

Function	Operation
@ABS	Return the absolute value of an expression
@AVG	Return the average value of the values in the specified member list
@EXP	Return the value of e (the base of natural logarithms) raised to power of the specified expression
@FACTORIAL	Return the factorial of an expression
@INT	Return the next-lowest integer value of a member or expression
@LN	Return the natural logarithm of a specified expression
@LOG	Return the logarithm to a specified base of a specified expression
@LOG10	Return the base-10 logarithm of a specified expression
@MAX	Return the maximum value among the expressions in the specified member list
@MAXS	Return the maximum value among the expressions in the specified member list, with the ability to skip zero and #MISSING values
@MIN	Return the minimum value among the expressions in the specified member list
@MINS	Return the minimum value among the expressions in the specified member list, with the ability to skip zero and #MISSING values
@MOD	Return the modulus produced by the division of two specified members
@POWER	Return the value of the specified member raised to the specified power
@REMAINDER	Return the remainder value of an expression
@ROUND	Return the member or expression rounded to the specified number of decimal places
@SUM	Return the summation of values of all specified members
@TRUNCATE	Return the truncated value of an expression
@VAR	Return the variance (difference) between two specified members. See Variances Between Actual and Budget Values.
@VARPER	Return the percentage variance (difference) between two specified members. See Variances Between Actual and Budget Values.