Avg

 

Purpose:

Generates the mean of the set of values that is produced by the first argument.

Parameter:

Number         Expression of the value to be calculated.

Boolean         (optional) TRUE: After the output, the values which were stored for the calculation are deleted. (default: TRUE). Please note that the stored calculation values are generally deleted for every (sub)table end. The second parameter only decides whether the values are already deleted within the table.

Return value:

Number

Example:

Avg(Order_Details.Quantity*Order_Details.UnitPrice)