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

See Also

  • @AVG