MEDIAN

The function will take all the child records for each parent record and calculate the median value from those records. Records with NULL values will be ignored

MEDIAN is defined as "the value found in the middle of an ordered set of data"

MEDIAN( <field_name>  [, <filter_query> ] )

Field_name: The field to return the value from.
Filter_query: A query string to represent the records to include in the calculation. If omitted then all records will be used.

Example: create a field at the CUSTOMER level to return the median cost of each customers purchases made in 2004.

MEDIAN( [Purchase.Purchase Value] , [Purchase.YEAR BANDING] = "2004" )