Sum

Analysis Services

Analysis Services

Sum

Returns the sum of a numeric expression evaluated over a set.

Syntax

Sum(«Set»[, «Numeric Expression»])

Example

If the respective values for the USA, CANADA and MEXICO members are 1000, 2000, and 3000, the following example returns 6000:

Sum({USA, CANADA, MEXICO}, Sales.VALUE)

The following example, which is more intuitive, is also valid:

Sum({USA, CANADA, MEXICO}, Sales)