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.
AVG – Find average of values
Overview
This Custom Field returns the average of a list of values such as ‘4,8,12’ or ‘11,15,8,17,22’ or ‘15.8,17.7,22.5’.
Syntax
AVG(4,8,12)
AVG(FIELDVAL(‘Size’),12)
| Element | Description |
|---|---|
| Argument1, Argument2 |
List of values |
Examples
AVG(4,8,12) returns 8.oo
AVG(11,15,8,17,22) returns 14.6o
AVG(15.8,17.7,22.5) returns 18.67
AVG(FIELDVAL(‘Size’),12) returns a value dependent on the value of the field ‘Size’. Size = 16 returns 14, Size = 6 returns 9.
See also