Design

Back Next

avg

Returns the average of the values in the input sequence given in the argument, that is, the sum of the values divided by the number of values.

fn:avg(arg)

The following table describes the argument for this command:

Argument	Required/Optional	Description
arg	Required	Numeric data type. Passes the values for which you want to calculate an average. You can enter any valid transformation expression.

Numeric value.

NULL if all values passed to the function are NULL.

The following table lists some sample values and return values:

The following expression returns the average wholesale cost of flashlights:

fn:avg( WHOLESALE_COST, ITEM_NAME='Flashlight' )

You can perform arithmetic on the values passed to AVG before the function calculates the average. For example:

fn:avg( QTY * PRICE - DISCOUNT )

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.