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

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.

See also

GROUPCOUNT

GROUPCOUNTUNIQUE

GROUPMAX

GROUPMIN

GROUPSUM

GROUPRTOTAL

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

Table of Contents