Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 705
Return value The datatype of the column. Returns the maximum value in the rows of
column. If you specify range,
Max returns the maximum value in column in
range.
Usage If you specify range, Max determines the maximum value in column in range.
If you specify DISTINCT,
Max returns the maximum distinct value in column,
or if you specify expresn, the maximum distinct value in column where the
value of expresn is distinct.
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 the following:
• For the Graph presentation style, Rows is always All.
Argument Description
column The column for which you want the maximum value. Column can
be the column name or the column number preceded by a pound
sign (#). Column can also be an expression that includes a reference
to the column. The datatype of column must be numeric.
FOR range
(optional)
The data that will be included when the maximum value is found.
For most presentation styles, values for range are:
• ALL – (Default) The maximum value of all rows in column.
• GROUP n – The maximum value of rows in column in the
specified group. Specify the keyword GROUP followed by the
group number: for example, GROUP 1.
• PAGE – The maximum value of the rows in column on a page.
For Crosstabs, specify CROSSTAB for range:
• CROSSTAB – (Crosstabs only) The maximum value of all rows
in column in the crosstab.
For Graph and OLE objects, specify one of the following:
• GRAPH – (Graphs only) The maximum value in column in the
range specified for the Rows option.
• OBJECT – (OLE objects only) The maximum value in column
in the range specified for the Rows option.
DISTINCT
(optional)
Causes
Max to consider only the distinct values in column when
determining the largest value. For a value of column, the first row
found with the value is used and other rows that have the same value
are ignored.
expresn
(optional)
One or more expressions that you want to evaluate to determine
distinct rows. Expresn can be the name of a column, a function, or
an expression.