@AVGRANGE

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

Syntax

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

SKIPNONEIncludes all cells specified in the average operation regardless of their content.
SKIPMISSINGExcludes all values that are #MISSING in the average operation.
SKIPZEROExcludes values of zero from the average calculation.
SKIPBOTHExcludes all values of zero or #MISSING from the average calculation.
mbrNameAny valid single member or member combination.
XrangeListOptional. 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, Analytic Services 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

See Also

@AVG

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com