|
Evaluates
a set of number values and/or expressions and returns the average
of the non-null elements contained within that set.
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.
ExamplesThe
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.
|
|
|
|
