Map and Table Calculation

AGGCNT( ) or ColumnAggregateCnt function

Counts the number of records which are not undefined in a column, or counts the number of records which are not undefined per group.

Syntax

AGGCNT(Column)
AGGCNT(Column, Group)
ColumnAggregateCnt(Column)
ColumnAggregateCnt(Column, Group)

Input

Column is a column
Domain type: any domain
Group is the 'group by' column
Domain type: any Class, ID, Group or Bool domain

Output

AGGCNT(Column) or ColumnAggregateCnt(Column)

returns:

a value

Domain:

system domain Count

 

AGGCNT(Column, Group) or ColumnAggregateCnt(Column, Group)

returns:

a value per group

Domain:

system domain Count

Notes:

Tips:

Usable in

TabCalc

Examples

TabCalc example:

OutCol1 = AGGCNT(CommVal)

OutCol2 = AGGCNT(CommVal,Landuse)

 

Parcel

Landuse

Area

CommVal

OutCol1

OutCol2

00123

Residential

4000

100000

6

4

00124

Residential

3500

250000

6

4

00125

Commercial

17500

?

6

?

00126

Residential

7500

400000

6

4

00127

Industrial

20000

20000000

6

1

01272

Institutional

12500

1250000

6

1

04625

Residential

5000

345000

6

4

 

See also:

AGGMED
AGGPRD
AGGSTD
CNT