The Median function finds the mathematical median of a column or group.


Syntax

Median(numbers)

Function arguments:

  • column (required) - The column of numbers to be evaluated.

If there is an even number of values, Median will interpolate between the middle values.


Example

Median([Temperature])

Find the median temperature value. If the column values are 3, 5, 7 and 20 the result would be 6.


Related Functions


Was this page helpful?
Yes No