Returns the maximum value of an entire column, or the maximum values per group.
Syntax
AGGMAX(ValueColumn)
AGGMAX(ValueColumn, Group)
ColumnAggregateMax(ValueColumn)
ColumnAggregateMax(ValueColumn, Group)
Input
ValueColumn | is a value column |
Domain type: | any Value domain |
Group | is the 'group by' column |
Domain type: | any Class, ID, Group or Bool domain |
Output
AGGMAX(ValueColumn) or ColumnAggregateMax(ValueColumn) |
|
returns: |
the maximum value of a column |
Domain: |
the value domain of the input column |
AGGMAX(ValueColumn, Group) or ColumnAggregateMax(ValueColumn, Group) |
|
returns: |
maximum values per group |
Domain: |
the value domain of the input column |
Notes:
Tips:
Usable in
Examples
TabCalc example:
OutCol1 = AGGMAX(CommVal)
OutCol2 = AGGMAX(CommVal,Landuse)
Parcel |
Landuse |
Area |
CommVal |
OutCol1 |
OutCol2 |
00123 |
Residential |
4000 |
100000 |
20000000 |
400000 |
00124 |
Residential |
3500 |
250000 |
20000000 |
400000 |
00125 |
Commercial |
17500 |
? |
20000000 |
? |
00126 |
Residential |
7500 |
400000 |
20000000 |
400000 |
00127 |
Industrial |
20000 |
20000000 |
20000000 |
20000000 |
01272 |
Institutional |
12500 |
1250000 |
20000000 |
125000 |
04625 |
Residential |
5000 |
345000 |
20000000 |
400000 |
See also:
Aggregate Column (dialog box) |