@AVG
The @AVG calculation function for Essbase returns the average from a list of numeric values.
Syntax
This function returns the average value among the results of the expressions in expList.
@AVG (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH, expList)
Parameters
- SKIPNONE
-
Includes all cells specified in the average operation regardless of their content.
- SKIPMISSING
-
Excludes all values that are
#MISSING
in the average operation. - SKIPZERO
-
Excludes values of zero from the average calculation.
- SKIPBOTH
-
Excludes all values of zero or
#MISSING
from the average calculation. - expList
-
Comma-delimited list of member names, variable names, functions, or numeric expressions. expList provides a list of numeric values across which the average is calculated.
Example
The following example is based on the Sample Basic database. The calculation averages the values for the individual states making up the western region and places the results in West:
FIX(Sales)
West=@AVG(SKIPBOTH,California:Nevada);
ENDFIX
This example produces the following report:
Sales Jan Actual
Cola Diet Cola Caffeine Free Cola
==== ========= ==================
California 678 118 145
Oregon 160 140 150
Washington 130 190 #MI
Utah 130 190 170
Nevada 76 62 #MI
West 234.8 140 155
See Also