@ACCUM

Accumulates the values of mbrName within rangeList, up to the current member in the dimension of which rangeList is a part.

Syntax

@ACCUM (mbrName [, rangeList])

mbrName Any valid single member name or member combination (or a function that returns a single member or member combination) whose value is to be accumulated.
rangeList Optional comma-delimited list of members, member set functions, or range functions, across which the accumulation occurs. If rangeList is not specified, Analytic Services uses the level 0 members from the dimension tagged as Time.

Notes

Example

In this example, Accum_Asset is calculated using the following formula:

"Accum Asset" = @ACCUM(Asset, FY1992:FY1995);

This example produces the following report. This report shows that the values for Asset are accumulated starting with FY1997 and the accumulated values are placed in Accum_Asset for FY1997 through FY2002:

             FY1997   FY1998   FY1999   FY2000   FY2001   FY2002
            =======  =======  =======  =======  =======  =======
Asset         9,000        0    1,000        0   2 ,500    1,500
Residual        750        0        0        0  #MISSING #MISSING
Life              5        0        3        0  #MISSING #MISSING
Accum_Asset #MISSING #MISSING   1,000    1,000    3,500    5,000

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