Find the median of a column or group.
Usage
Median(numbers)
numbers (required) The column of numbers to be evaluated.
NOTE: 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 were 3, 5, 7 and 20 the result would be 6.