Returns the minimum value of an entire column, or the minimum values per group.
Syntax
AGGMIN(ValueColumn)
AGGMIN(ValueColumn, Group)
ColumnAggregateMin(ValueColumn)
ColumnAggregateMin(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
AGGMIN(ValueColumn) or ColumnAggregateMin(ValueColumn) |
|
returns: |
the minimum value of a column |
Domain: |
the value domain of the input column |
AGGMIN(ValueColumn, Group) or ColumnAggregateMin(ValueColumn, Group) |
|
returns: |
a minimum value per group |
Domain: |
the value domain of the input column |
Notes:
Tips:
Usable in
Examples
TabCalc example:
OutCol1 = AGGMIN(CommVal)
OutCol2 = AGGMIN(CommVal,Landuse)
Parcel |
Landuse |
Area |
CommVal |
OutCol1 |
OutCol2 |
00123 |
Residential |
4000 |
100000 |
100000 |
100000 |
00124 |
Residential |
3500 |
250000 |
100000 |
100000 |
00125 |
Commercial |
17500 |
? |
100000 |
? |
00126 |
Residential |
7500 |
400000 |
100000 |
100000 |
00127 |
Industrial |
20000 |
20000000 |
100000 |
20000000 |
01272 |
Institutional |
12500 |
1250000 |
100000 |
125000 |
04625 |
Residential |
5000 |
345000 |
100000 |
100000 |
See also:
Aggregate Column (dialog box) |