@AVGRANGE

Returns the average value of the specified member (mbrName) across the specified range (XrangeList).

Syntax

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

Parameter	Description
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.
XrangeList	Optional. A valid member name, a comma-delimited list of member names, cross dimension members, or a member set function or range function (including @XRANGE) that returns a list of members from the same dimension. If XrangeList is not specified, 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 calculation 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