Max

Return to: Calculated Member Builder Function List

Returns the maximum value of a numeric expression evaluated over a set.

Syntax

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

Example

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

returns 3000 if respective Sales of the countries are 1000, 2000, and 3000.