Returns the sum of a numeric expression evaluated over a set.
If a numeric expression is specified, the specified numeric expression is calculated for each set member and then sum of all these results is returned. If a numeric expression is not specified, the specified set is evaluated in the current context of the members of the set and then summed.
Syntax
Sum( Set_Expression , Numeric_Expression )
Arguments
|
Set_Expression |
MDX expression that returns a set. |
|---|---|
|
Numeric_Expression |
MDX expression that returns a number. |
Examples
This examples gives the sum of the current context value over the last 12 months.
sum([Time].[Month].CurrentDateMember.Lag(12) : [Time].[Month].CurrentDateMember)
See also