Average Function

Returns the average of a specified field or expression across a collection.

Syntax 1

Avg(collection, field)

Returns the average of a specified field or expression across a collection.

Arguments

collection Collection - A collection.

field Field - The field to average.

Syntax 2

Average(collection, expression)

Returns the average of a specified field or expression across a collection.

Arguments

collection Collection - A collection.

expression Numeric - An expression that resolves to a number.

Syntax 3

Avg(collection, field, filter)

Returns the average of a specified field or expression across a collection.

Arguments

collection Collection - A collection.

field Field - The field to average.

filter FilterExpression - Filter criteria.

Syntax 4

Average(collection, expression, filter)

Returns the average of a specified field or expression across a collection.

Arguments

collection Collection - A collection.

expression Numeric - An expression that resolves to a number.

filter FilterExpression - Filter criteria.

Remarks

• Arguments after the collection argument are evaluated in the context of a collection member.

Example:

Avg(Vehicles, BI_PD.Premium, Year=1999); // returns 4096.75