Essbase @SUM

Returns the summation of all the values in expList.

Syntax

@SUM (expList)
Parameter Description
expList Comma-delimited list of member specifications, variable names, or numeric
expressions, all of which provide numeric values.

Example

In the Sample Basic database:

FIX("Total Expenses")
West=@SUM(West,East);
ENDFIX

Since the calculation script fixes on Total Expenses, the value for
Total Expenses->West is equal to the sum of the value for East and the values
for the states making up the West. For Sales, West and East are simply the
sum of the states making up each region (that is, Sales->West is not equal
to the sum of East and West). This example produces the following report:

                  Product    Qtr1    Actual
                   Sales    Total Expenses
                   =====    ==============
New York            7705        2068
Massachusetts       3660         892
Florida             4132        1313
Connecticut         3472        1087
New Hampshire       1652         801
  East             20621        6161
California         11056        2742
Oregon              5058        1587
Washington          4835        1621
Utah                4209        1544
Nevada              6516        2193
  West             31674       15848

See Also

  • @SUMRANGE