Top  | Previous | Next

Aggregates / median

median(dataset, column OR number, number...)

Calculates the median for the numbers in the given column of the given dataset or the median of a series of numbers specified as arguments. When looking up the median in a dataset, the column may be specified as an index or as a column name. Any null values in the column are ignored. If there are no rows in the dataset, zero is returned.

 

For example, suppose you had a table with this dataset in it:

ProductCode

Quantity

Weight

BAN_002

380

3.243

BAN_010

120

9.928

APL_000

125

1.287

FWL_220

322

7.889

 

median({Root Container.Table.data}"Weight")

... would return 5.566

 

median(1,2,3,3,10)

... would return 3