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
.
|
|
|
|