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
See also