@ACCUM

The @ACCUM() function 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 from the same dimension, across which the accumulation occurs. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.

Notes

Financial functions never return a value; rather, they calculate a series of values internally based on the range specified.
@ACCUM accepts the @ATTRIBUTE member set function as a member range.
If you use a Hyperion Essbase member set function to generate a member list for the rangeList parameter (for example, @SIBLINGS), to ensure correct results, consider the order in which Hyperion Essbase sorts the generated member list. For more information, see the online Technical Reference topic for the member set function you are using.

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 FY1992 and the accumulated values are placed in Accum_Asset for FY1992 through FY1995:

             FY1990   FY1991   FY1992   FY1993   FY1994   FY1995
            =======  =======  =======  =======  =======  =======

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

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 from the same dimension, across which the accumulation occurs. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.