AVG (AVERAGE) Function

The AVG or AVERAGE calculation function returns the average of a set of numbers as defined in the parameters. The AVG function can be used in Line or Column Definition calculations.

Command Syntax:

AVG([parameter1], [parameter2], [parameter3]… )

AVG([parameter1]:[parameter2])

EXAMPLE:

This formula sets a line to the average value of a set of parameters.

AVG([16],[17])

Line Definition

Report Output

EXAMPLE:

This formula sets a line to the average value of a range of parameters (where 5000 represents the Code for the start of the range and 5250 the Code for the last value in the range).

AVG([5000]:[5250])

Note: Beginning with Prospero version 2.1.1095, the term AVERAGE can be used interchangeably with AVG. The two terms are functionally identical within Prospero.

Also see the topic Using Ranges in Formulas.