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: |
|
AGGCNT(Column, Group) or ColumnAggregateCnt(Column, Group) |
|
returns: |
a value per group |
Domain: |
Notes:
Tips:
Usable in
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 | ||
Aggregate Column (dialog box) |