Specifications

CrosstabMin
662 InfoMaker
Syntax CrosstabMaxDec ( n {, column, groupvalue } )
Return value Decimal. Returns the maximum value returned by expression n for all the
column values or, optionally, for a subset of column values.
Usage Use this function instead of CrosstabMax when you want to return a decimal
datatype instead of a double datatype. For more information, see
CrosstabMax.
See also CrosstabAvgDec
CrosstabMinDec
CrosstabSumDec
CrosstabMin
Description Calculates the minimum value returned by an expression in the values list of
the crosstab. When the crosstab definition has more than one column,
CrosstabMin can also calculate the minimum of the expression’s values for
groups of column values.
For crosstabs only
You can use this function only in a crosstab report.
Syntax CrosstabMin ( n {, column, groupvalue } )
Argument Description
n The number of the crosstab-values expression for which you want
the maximum returned value. The expression’s datatype must be
numeric.
column
(optional)
The number of the crosstab column as it is listed in the Columns box
of the Crosstab Definition dialog box for which you want
intermediate calculations.
groupvalue
(optional)
A string whose value controls the grouping for the calculation.
Groupvalue is usually a value from another column in the crosstab.
To specify the current column value in a dynamic crosstab, rather
than a specific value, specify @ plus the column name as a quoted
string.
Argument Description
n The number of the crosstab-values expression for which you want
the minimum return value. The expression’s datatype must be
numeric.