Sum

Return to: Calculated Member Builder Function List

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

Syntax

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

Example

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

returns 6000 if their respective Sales are 1000, 2000, and 3000. This can also be written in a more intuitive way as

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