Essbase @SUMRANGE

Returns the summation of all the values of the specified member across
the specified range.

Syntax

@SUMRANGE (mbrName [, XrangeList])
Parameter Description
mbrName Any valid single member name or member combination, or a function that
returns a 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 @SUMRANGE function does not accept a cross-dimensional
    parameter as a member name.
  • This function returns the summation of all the values of the
    specified member (mbrName) across the specified
    range (XrangeList).

Example

The following example is based on the Sample Basic database. Assume
that the Year dimension contains an additional member, Partial Year. The formula
for Partial Year sums the values for New York across the range of Jan through
Jun. The calculation script fixes on Sales, so this formula is applied only
to Sales values.

FIX(Sales)
"Partial Year"=@SUMRANGE("New York",Jan:Jun);
ENDFIX
This example produces the following report:
           Actual   New York   Colas
                     Sales
                     =====
Jan                   678
Feb                   645
Mar                   675
Apr                   712
May                   756
Jun                   890
Partial Year         4356

See Also

  • @SUM