GROUPCOUNT

GROUPCOUNT

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_

Name

Item

Customer_

Name

Item

2535

Jon

Zamioculcas

2888

Mike

Spider Lily

2535

Jon

Datura

2535

Jon

Dahlia

8654

 

Windflower

5788

Jon

Snapdragon

2888

Mike

Marguerite

2535

Jon

Windflower

2888

Mike

Elephant's Ear

2535

Jon

Chinese Evergreen

5788

Jon

Begonia

5788

Jon

Starfish Plant

2535

Jon

Hare's Foot Fern

2535

Jon

Venus Flytrap

3545

Monique

Red Flame Ivy

8654

 

Starfish Plant

4587

 

Begonia

1234

<error>

Elephant's Ear

4321

<error>

Snapdragon

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

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

 

Name

 

<error>

<error>

 

3

Jon

10

Mike

3

Monique

1