Name
avg — Returns average value of all its arguments.
Synopsis
number
avg
(
|
arg1 any , |
| arg2 any , | |
| ... , | |
argN
any
); |
Description
The function returns the average of all values in all its arguments, For each node in every argument node-set, it converts the string-value of the node to a number and adds the result to the sum. If some arguments are not node-sets, they are converted to numbers first and added to the sum. Then sum is divided by number of values added and the result is returned.
This function is not a part of XPATH 1.0 standard library.
Parameters
argI
A node-set of nodes whose string values must be converted to numbers and added to the result, or single value.
Return Types
Table 24.137. Errors signalled by
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
| XP001 | XPF06 | Nonempty sequence of values expected as argument(s) of XPATH function avg(); avg() of nothing is senseless | This happens if the function is called without arguments, or with all arguments set to empty node-sets. |
Examples
Example 24.565.
avg(/report[@type="daily-sales"]/total)