@SUMRANGE

The @SUMRANGE() function returns the summation of all the values of the specified member (mbrName) across the specified range (rangeList).

Syntax

@SUMRANGE(mbrName [, rangeList])

mbrName Any valid single member name or member combination, or a function that returns a single member or member combination.

rangeList Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions from the same dimension. If rangeList is not specified, Hyperion 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 calc 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

mbrName	Any valid single member name or member combination, or a function that returns a single member or member combination.
rangeList	Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions from the same dimension. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.