Median Function
Description:
The middle value in a list of numbers.
If the list count is odd:
Returns the middle number when the list is sorted in ascending order.
If the list count is even:
Returns the mean of the two middle numbers when the list is sorted in ascending order.
note
This function is non-evaluable if the list does not contain any members.
Returns:
Number
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Number* | The list of numbers. |
Examples:
When using functions inside a field, remember the field brackets:
{Median(InterestRateComparison)}
Expression | Result |
|---|---|
Median( List(4,1,5,2,3,7,6) ) | 4 |
Median( List(4,1,5,2,3,7,6,8) ) | 4.5 |
Related Content
-
List Functions
Format:
Article,
1 min read