Description

Returns the arithmetic mean value of a multi-value or a list of values

Syntax

AVERAGE(m1)

AVERAGE(v1, v2[, v]*)

·        m1: a multi-valued field or attribute

·        v: two or more values

Example

Given a multi-valued attribute of Lengths {2, 4, 9}:

AVERAGE(Length)        ® 5

AVERAGE(2, 11, 11, 0)  ® 6