Specifications

Avg

646 InfoMaker

Not in validation rules or filter expressions

You cannot use this or other aggregate functions in validation rules or filter

expressions.

Using an aggregate function cancels the effect of setting Retrieve Rows As

Needed in the painter. To do the aggregation, a report always retrieves all rows.

Examples This expression returns the average of the values in the column named salary:

Avg(salary)

This expression returns the average of the values in group 1 in the column

named salary:

Avg(salary for group 1)

This expression returns the average of the values in column 5 on the current

page:

Avg(#5 for page)

This computed field returns Above Average if the average salary for the page

is greater than the average salary:

If(Avg(salary for page) > Avg(salary), "Above Average",

" ")

This expression for a graph value sets the data to the average value of the

sale_price column:

Avg(sale_price)

This expression for a graph value sets the data value to the average value of the

sale_price column for the entire graph:

Avg(sale_price for graph)

Assuming a report displays the order number, amount, and line items for each

order, this computed field returns the average of the order amount for the

distinct order numbers:

Avg(order_amt for all DISTINCT order_nbr)