Avg

Evaluates a set of number values and/or expressions and returns the average of the non-null elements contained within that set.

Syntax

Avg(n1 [, n2 ...])

Parameters

Parameter

Description

n1

The first numeric value or expression of the set.

n2 (optional)

Additional numeric values or expressions.

Note: FormCalc follows the IEEE-754 international standard when handling floating point numeric values. For more information, see Number literals.

Examples

The following expressions are examples of using the Avg function:

Expression

Returns

Avg(0, 32, 16)

16

Avg(2.5, 17, null)

9.75

Avg(Price[0], Price[1], Price[2], Price[3])

The average value of the first four non-null occurrences of Price.

Avg(Quantity[*])

The average value of all non-null occurrences of Quantity.

// Ethnio survey code removed