Returns the sum of values of tuples in a set.
Sum ( set [,numeric_value_expression ] )
set | The set containing the tuples to aggregate. If empty, the return value is #Missing. |
numeric_value_expression | Optional. An expression that returns a value. Commonly used to restrict the aggregation to a slice from a Measures dimension. In the example below, [Measures].[Total Expenses] is the numeric value expression provided to the Sum function. |
For each tuple in set, the numeric value expression is evaluated in that tuple's context and the resulting values are summed up.
The return value of Sum is #MISSING if either of the following is true:
WITH MEMBER [Market].[Sum Expense for Main States] AS 'Sum ({[Market].[California], [Market].[Colorado], [Market].[Texas], [Market].[Illinois], [Market].[Ohio], [Market].[New York], [Market].[Massachusetts], [Market].[Florida]}, [Measures].[Total Expenses] )' SELECT {[Measures].[Total Expenses]} ON COLUMNS, {UDA([Market], "Major Market"), [Market].[Sum Expense for Main States]} ON ROWS FROM Sample.Basic WHERE ([Scenario].[Actual])
returns the grid:
Total Expenses | |
---|---|
New York | 8914 |
Massachusetts | 3412 |
Florida | 5564 |
East | 25310 |
California | 11737 |
Texas | 4041 |
Illinois | 6900 |
Ohio | 5175 |
Colorado | 6131 |
Central | 34864 |
Sum Expense for Main States | 51874 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |