avg
Returns average value of all its arguments.
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.
Table: 23.1. 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
avg(/report[@type="daily-sales"]/total)