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

CurrentDateMember

Lag