@SUMRANGE

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

Syntax

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

Description

This function returns the summation of all the values of the specified member (mbrName) across the specified range (XrangeList).

Note

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

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com