Maths functions

GROUPCOUNT – Count groups or records in a group

422 views June 1, 2018 admin 0

Overview

This Custom Field returns the number of groups or records in a group.

Syntax

GROUPCOUNT(‘Parent Category:Child Category’)

Element Description
Parent Category:Child Category Group path delimited by colons

Examples

For the table below, GROUPCOUNT(‘Category1ID:Category2ID:CollectionID’) will return 4 as there are 4 product rows.

Category1ID Category2ID CollectionID ProductName Price
25 136 1924 Apple 9.99
25 136 1924 Banana 11.00
25 136 1924 Cantaloupe 48.95
25 136 1924 Durian 29.99

See also

GROUPCOUNTUNIQUE

GROUPAVG

GROUPMAX

GROUPMIN

GROUPSUM

GROUPRTOTAL

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

 

Was this helpful?