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.
GROUPSUM – Calculate total of given field in group
Overview
This Custom Field adds the values of a given field in a group and returns the total of those values.
Syntax
GROUPSUM(‘GroupPath’, ‘FieldName’)
GROUPSUM(‘Parent Category:Child Category’,‘Price’)
Element | Description |
---|---|
‘GroupPath’ | Group path delimited by colons. |
‘SortField’ | The field whose values are to be added. |
Example
GROUPSUM(‘Parent Category:Child Category’,‘Price’)
In this example the total all of the Price fields Child Category grouping are added, with the total of all values returned for each value.
Price |
GROUPSUM |
12.00 |
51.00 |
17.00 |
51.00 |
22.00 |
51.00 |