| Median | (standard MDX) |
Returns the median value of the specified set expression.
Parameters
| Name | Type | Cardinality | Default value |
| set-expression | one | ||
| value-expression | zero-one |
Return
value
Description
The median function calculates the median value of the non-empty cells.
1) A value expression is specified.
When the value expression is specified, the measure is evaluated over the set and its median value is returned.
2) A value expression is not specified.
If a value expression is not specified, the measure is taken from the current context.
How is the median value calculated ?
After sorting the set, the median value depends on the number of items :
a) if it's an odd number : returns the value of the member in the middle of the set.
b) if it's an even number : returns the average value of the two member in the middle of the set.
Examples
Special Examples (errors, null, ...)
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.