Map and Table Calculation

AGGMIN( ) or ColumnAggregateMin() function

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

TabCalc

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: