Median

Return to: Calculated Member Builder Function List

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

Syntax

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

Example

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

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

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.