Median() returns the aggregated median of the values in the expression over a number of records as defined by a group by clause.
Return data type: numeric
|expr||The expression or field containing the data to be measured.|
Examples and results:
Add the example script to your app and run it. Then build a straight table with Type and MyMedian as dimensions.
crosstable LOAD recno() as ID, * inline [
25|2 ] (delimiter is '|');
Median(Value) as MyMedian
Resident Table1 Group By Type;
The results of the Median() calculation are: