Maths functions

GROUPAVG – Calculate average value of field in group

57 views June 1, 2018 admin 0

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

Was this helpful?