Welcome to Catalog Tips

Search more than 200 articles to learn more about creating and automating your product catalogs

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

GROUPCOUNT – Count groups or records in a group

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

 

Table of Contents