Map and Table Calculation

AGGMAX( ) or ColumnAggregateMax() function

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

TabCalc

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: