ColMin

The ColMin function returns the smallest value in a column of numbers.

ColMin (numbers, break_col, break_value)

where:

numbers references the column that contains the numbers on which the count of minimum column value is calculated.

break_col is an optional parameter that references a break column.

break_value is an optional parameter that returns the minimum value of numbers column where value in break_col equals break_value.

Note:

If constant values in the break_value column are substituted for data items, dates and text strings must be enclosed in single quotes.

The following examples show the results of inserting the ColMin function in three separate tables.

Example 1

In this example, the ColMin function is used on the numeric column. The results are shown in the Computed column.

ColMin (Amount)

Table 149. ColMin Example 1

State	City	Amount	Computed
AZ	Tucson	112	70
CA	Burbank	240	70
CA	Glendale	NULL	70
FL	Palmetto	70	70
MD	Laurel	97	70
MI	Detroit	208	70
MN	Eagan	159	70
NY	New York	490	70
NY	Rochester	180	70

Example 2

In this example, the ColMin function is used on the numeric column and break_column. The results are shown in the Computed column.

ColMin (Amount, State)

Table 150. ColMin Example 2

State	City	Amount	Computed
AZ	Tucson	112	112
CA	Burbank	240	240
CA	Glendale	Null	240
FL	Palmetto	70	70
MD	Laurel	97	97
MI	Detroit	208	208
MN	Eagan	159	159
NY	New York	490	180
NY	Rochester	180	180