@AVGRANGE

The @AVGRANGE() function returns the average value of the specified member (mbrName) across the specified range (rangeList).

Syntax

@AVGRANGE( SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH, mbrName [, rangeList])

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.

mbrName Any valid single member or member combination.

rangeList Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions from the same dimension. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.

Notes

The @AVGRANGE function accepts the @ATTRIBUTE member set function as a member range.

Example

The following example is based on the Sample Basic database. The calc script determines the average sales of Colas in the West.

FIX(Sales)
West=@AVGRANGE(SKIPNONE,Sales,@CHILDREN(West));
ENDFIX

This example produces the following report:

              Sales   Colas   Actual
                Jan    Feb    Mar
                ===    ===    ===
				
California      941    899    927
Oregon          450    412    395
Washington      320    362    377
Utah            490    488    476
Nevada          138    137    138
  West         467.8   459.6  462.6

See Also

@AVG

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.
mbrName	Any valid single member or member combination.
rangeList	Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions from the same dimension. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.