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 |
---|---|
Return the absolute value of an expression |
|
Return the average value of the values in the specified member list |
|
Return the value of e (the base of natural logarithms) raised to power of the specified expression |
|
Return the factorial of an expression |
|
Return the next-lowest integer value of a member or expression |
|
Return the natural logarithm of a specified expression |
|
Return the logarithm to a specified base of a specified expression |
|
Return the base-10 logarithm of a specified expression |
|
Return the maximum value among the expressions in the specified member list |
|
Return the maximum value among the expressions in the specified member list, with the ability to skip zero and #MISSING values |
|
Return the minimum value among the expressions in the specified member list |
|
Return the minimum value among the expressions in the specified member list, with the ability to skip zero and #MISSING values |
|
Return the modulus produced by the division of two specified members |
|
Return the value of the specified member raised to the specified power |
|
Return the remainder value of an expression |
|
Return the member or expression rounded to the specified number of decimal places |
|
Return the summation of values of all specified members |
|
Return the truncated value of an expression |
|
Return the variance (difference) between two specified members. |
|
Return the percentage variance (difference) between two specified members. |