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

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

See also

GROUPCOUNT

GROUPCOUNTUNIQUE

GROUPAVG

GROUPMAX

GROUPMIN

GROUPRTOTAL

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

Table of Contents