Function Index

Median

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.

Examples

Median([Temperature])
  • Find the median temperature value. If the column values were 3, 5, 7 and 20 the result would be 6.