Specifications

Median
708 InfoMaker
Settings for Rows include the following:
• For the Graph presentation style, Rows is always All.
• For Graph controls, Rows can be All, Page, or Group.
• For OLE controls, Rows can be All, Current Row, Page, or Group. The
available choices depend on the layer the control occupies.
In calculating the median, null values are ignored.
Not in validation rules or filter expressions
You cannot use this or other aggregate functions in validation rules or filter
expressions.
Using an aggregate function cancels the effect of setting Retrieve Rows As
Needed in the painter. To do the aggregation, a report always retrieves all rows.
Examples This expression returns the median of the values in the column named salary:
Median(salary)
This expression returns the median of the values in the column named salary
of group 1:
Median(salary for group 1)
This expression returns the median of the values in column 5 on the current
page:
Median(#5 for page)
This computed field returns Above Median if the median salary for the page is
greater than the median for the report:
If(Median(salary for page) > Median(salary), "Above
Median", " ")
This expression for a graph value sets the data value to the median value of the
sale_price column:
Median(sale_price)
This expression for a graph value entered on the Data page in the graph’s
property sheet sets the data value to the median value of the sale_price column
for the entire graph:
Median(sale_price for graph)