Maths functions

AVG – Find average of values

143 views June 1, 2018 admin 0

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

MIN

MAX

SUM

FIELDVAL

 

 

Was this helpful?