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.
GROUPAVG – Calculate average value of field in group
Overview
This Custom Field returns the average value of a given field in a group.
Syntax
GROUPAVG(‘GroupPath’,‘FieldName’)
Element | Description |
---|---|
GroupPath | The group path, delimited by colons |
FieldName | The field whose values will be averaged |
Example
GROUPAVG(‘Parent Category:Child Category’,’Price‘) where Price contains values 1,2,5,6,10,12 returns 6.