Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 739
Return value The datatype of returnexp. Returns the nbottom-smallest value if it succeeds
and -1 if an error occurs.
Usage If you specify range, Small returns the value in returnexp when the value in
column is the nbottom-smallest value in range. If you specify DISTINCT,
Small returns returnexp when the value in column is the nbottom-smallest value
of the distinct values in column, or if you specify expresn, the
nbottom-smallest for each distinct value of expresn.
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.
nbottom The relationship of the small value to the column’s smallest value.
For example, when nbottom is 2, Small finds the second-smallest
value.
FOR range
(optional)
The data that will be included when finding the small value. For
most presentation styles, values for range are:
• ALL – (Default) The small value of all rows in column.
• GROUP n – The small value of rows in column in the specified
group. Specify the keyword GROUP followed by the group
number: for example, GROUP 1.
• PAGE – The small value of the rows in column on a page.
For Crosstabs, specify CROSSTAB for range:
• CROSSTAB – (Crosstabs only) The small value of all rows in
column in the crosstab.
For Graph and OLE objects, specify one of the following:
• GRAPH – (Graphs only) The small value in column in the range
specified for the Rows option.
• OBJECT – (OLE objects only) The small value in column in the
range specified for the Rows option.
DISTINCT
(optional)
Causes
Small to consider only the distinct values in column when
determining the small 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.
Argument Description