Specifications

Space

740 InfoMaker

Settings for Rows include the following:

• For the Graph or OLE 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.

Min might be faster If you do not need a return value from another column

and you want to find the smallest value (nbottom = 1), use

Min; it is faster.

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 These expressions return the names of the salespersons with the three smallest

sales (sum_sales is the sum of the sales for each salesperson) in group 2, which

might be the salesregion group. Note that sum_sales contains the values being

compared, but

Small returns a value in the name column:

Small(name, sum_sales, 1 for group 2)

Small(name, sum_sales, 2 for group 2)

Small(name, sum_sales, 3 for group 2)

This example reports the salesperson with the third-smallest sales, considering

only the first entry for each salesperson:

Small(name, sum_sales, 3 for all DISTINCT sum_sales)