Livecycle

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.

Avg