Tinderbox 7 Icon

avg(group,value)


Operator Type: 

Operator Scope of Action: 

Operator Purpose: 

Operator First Added: 

Operator Altered: 

 Function   [other Function type actions]

 Group   [operators of similar scope]

 Mathematical   [other Mathematical operators]

 Baseline

 


avg(group,value)

This computes the arithmetic mean of a value in a group. See avg_if() for a for a related conditional operator.

group describes the notes to be examined and may be any group designator including a find() query.

value may be any valid expression, but will usually be a reference to an attribute; short form Boolean attribute expressions are acceptable.

For example:

avg(children(/Catalog),$Price) 

returns the average price of all the items in Catalog.