Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 715
For graphs and OLE objects, you do not select the range when you call the
function. The range has already been determined by the Rows setting on the
Data property page (the Range property), and the aggregation function uses
that range. Settings for Rows include:
• For the Graph or OLEpresentation 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 mode, 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 mode of the values in the column named salary:
Mode(salary)
This expression returns the mode of the values for group 1 in the column named
salary:
Mode(salary for group 1)
This expression returns the mode of the values in column 5 on the current page:
Mode(#5 for page)
This computed field returns Above Mode if the mode of the salary for the page
is greater than the mode for the report:
If(Mode(salary for page) > Mode(salary), "Above
Mode", " ")
This expression for a graph value sets the data value to the mode of the
sale_price column:
Mode(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 mode of the sale_price column for the
entire graph:
Mode(sale_price for graph)