@SUM

The @SUM calculation function for Essbase returns the summation of all the values in expList.

Syntax

@SUM (expList)

Parameters

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