@SUM

Function

The @SUM() function returns the summation of all the values in expList.

Syntax

@SUM (expList)

expListComma-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 calc 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


Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.