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, Analytic Services uses the level 0 members from the dimension tagged as time. |
This function returns the summation of all the values of the specified member (mbrName) across the specified range (XrangeList).
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
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |