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

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

Example24.565.

avg(/report[@type="daily-sales"]/total)

See Also

sum max min