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.

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

This article applies to: