Returns the summation of all the values of the specified member (mbrName) across the specified range (XrangeList).
Syntax
@SUMRANGE (mbrName [,XrangeList])
Parameter | Description | ||
---|---|---|---|
mbrName | Any valid single member name, or a function that returns a single member.
| ||
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. |
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