Table of Contents
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.