Table of Contents
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