Specifications

Large
692 InfoMaker
Large
Description Finds a large value at a specified ranking in a column (for example, third-
largest, fifth-largest) and returns the value of another column or expression
based on the result.
Syntax Large ( returnexp, column, ntop { FOR range { DISTINCT { expres1
{, expres2 {, ... } } } } } )
Argument Description
returnexp The value you want returned when the large value is found.
Returnexp includes a reference to a column, but not necessarily the
column that is being evaluated for the largest value, so that a value is
returned from the same row that contains the large value.
column The column that contains the large value you are searching for.
Column can be a column name or a 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.
ntop The ranking of the large value in relation to the column’s largest
value. For example, when ntop is 2,
Large finds the second-largest
value.
FOR range
(optional)
The data that will be included when the largest value is found. For
most presentation styles, values for range are:
• ALL – (Default) The largest of all values in column.
• GROUP n – The largest of values in column in the specified group.
Specify the keyword GROUP followed by the group number: for
example, GROUP 1.
• PAGE – The largest of the values in column on a page.
For Crosstabs, specify CROSSTAB for range:
• CROSSTAB – (Crosstabs only) The largest of all values in column
in the crosstab.
For Graph and OLE objects, specify one of the following:
• GRAPH – (Graphs only) The largest of values in column in the
range specified for the Rows option.
• OBJECT – (OLE objects only) The largest of values in column in
the range specified for the Rows option.
DISTINCT
(optional)
Causes
Large to consider only the distinct values in column when
determining the large 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 need to evaluate to determine
distinct rows. Expresn can be the name of a column, a function, or an
expression.