Using QMF

AVG. -- Calculate the average value

The AVG. column function calculates the average of all values in a column for rows selected. It applies to numeric data and returns a single value for that data. You can use the UNQ. operator with AVG. to use only unique values when calculating the average. A column function does not include null values in its calculation.

To select only the SALARY column, define an example element for SALARY in the SALARY column. Then, add an unnamed column, request the average, and put the example element in the unnamed column.

When you run this query:

Q.STAFF | SALARY |         |
--------+--------+---------|
        | _S     |P.AVG._S |

QMF produces this report:

       AVG(SALARY)
------------------
  16675.6422857142

To find the average of the values in the SALARY column for clerks only, add a condition to your query:

When you run this query:

Q.STAFF | SALARY | JOB   |          |
--------+--------+-------+----------|
        | _S     | CLERK | P.AVG._S |

QMF produces this report:

       AVG(SALARY)
------------------
  12612.6125000000

Rules for AVG.

• You can only use AVG. on columns of numeric data.
• In an unnamed column, you must specify AVG. along with the example element that identifies the column to be averaged.
• AVG. can be followed by an example element, an arithmetic expression that contains at least one example element, or the UNQ. operator that is followed by an example element. If the data in a column you want to average is defined by an arithmetic expression, enclose the expression in parentheses.
• When you apply AVG. to one column named in an example table, you must apply a column function (AVG., MIN., MAX., COUNT., OR SUM.) or the G. (group) operator to every other column selected.