@AVG

Function

The @AVG() function returns the average of all values in expList.

Syntax

@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.

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(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

See Also

@AVGRANGE

Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.