Returns the average of all values in expList.
@AVG (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH, expList)
| 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. |
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(SKIPNONE,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
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |