Page tree
Skip to end of metadata
Go to start of metadata

Syntax

GROUPCOUNT()

Description

Counts the records in one group. No calculations are performed with this function. 

Empty or <null> records of a group are calculated into GROUPCOUNT().

The GROUPCOUNT function results in an error only if the grouping itself contains an error. 

This is an aggregate function

Example

Given the following data:

Customer_NameItem
2535JonZamioculcas
2888MikeSpider Lily
2535JonDatura
2535JonDahlia
8654
Windflower
5788JonSnapdragon
2888MikeMarguerite
2535JonWindflower
2888MikeElephant's Ear
2535JonChinese Evergreen
5788JonBegonia
5788JonStarfish Plant
2535JonHare's Foot Fern
2535JonVenus Flytrap
3545MoniqueRed Flame Ivy
8654
Starfish Plant
4587
Begonia
1234<error>Elephant's Ear
4321<error>Snapdragon

First create a group using GROUPBY(#RawData!Name)

Name
<error>

Jon
Mike
Monique

Use GROUPCOUNT() to return the amount of times a given argument appears, in relation to the GROUPBY() column.

Name
<error><error>

3
Jon10
Mike3
Monique1
  • No labels