The Median function returns the median of a column of numbers. The median is the middle value or number in the middle of a set of numbers (and not the average).
numbers references the column that contains the numbers on which the median is calculated.
break_col is an optional parameter that references a break column.
The following examples show the results of inserting the Median function in two separate tables.
In this example, the Median function is used on a numeric column that has an odd number of rows:
Median (Amount)
The Median function returns the number in the middle, which in this example is 30.
If the numbers column has an even number of rows, the Median function calculates the average of the two numbers in the middle.