Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 663
Return value Double. Returns the minimum value returned by expression n for all the
column values or, optionally, for a subset of column values. To return a decimal
datatype, use
CrosstabMinDec.
Usage This function is meaningful only for the minimum of the values of the
expression in a row in the crosstab. This means you can use it only in the detail
band, not in a header, trailer, or summary band.
Null values are ignored and are not included in the comparison.
For more information about restricting the calculation to groups of values when
the crosstab definition has more than one column, see Usage for
CrosstabAvg.
Reviewing the expressions
To review the expressions defined for the crosstab values, open the Crosstab
Definition dialog box (select Design>Crosstab from the menubar).
Examples These examples all use the crosstab-values expressions shown below:
Count(emp_id for crosstab),Sum(salary for crosstab)
This expression for a computed field in the crosstab returns the minimum of the
employee counts (the first expression):
CrosstabMin(1)
This expression for a computed field in the crosstab returns the minimum of the
salary totals (the second expression):
CrosstabMin(2)
The next two examples use a crosstab with two columns (year and quarter), a
row (product), and the values expression Avg(sales for crosstab).
This expression for a computed field returns the smallest of the quarterly
average sales for each year:
CrosstabMin(1, 2, "@year")
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