The ColMax function returns the largest value in a column of numbers.
ColMax (numbers, break_col, break_value)
numbers references the column that contains the number on which the maximum column value is calculated.
break_col is an optional parameter that references a break column.
break_value is an optional parameter that returns the maximum value of numbers column where value in break_col equals break_value.
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 ColMax function in three separate tables.
In this example, the ColMax function is used on the numeric column. The results are shown in the Computed column.
ColMax(Amount)