Percentage of Average

A report percentage of average column calculates the average of the values in the specified column, and then returns the percentage of that total of the value in the current row.

For example, if you had a column with three rows whose values were 10, 20, and 30, the average of the values in the column would be 20. The values returned in the report percentage of average column would be derived by dividing the value in each row by the average value of the column, and multiplying the result by 100. In this example, the values returned would be 50%, 100%, and 150%, respectively.