Returns the summation of all the values of the specified member across
the specified range.
@SUMRANGE (mbrName [, XrangeList])
|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.
- 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
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