Percent Difference from Average
Function Performed — Performs the same actions as Difference from Average but displays each result as a percentage of average.
Number of Arguments — One member or calculation.
Options — Whether missing values should be set to 0 in the calculation.
Example — Consider a spreadsheet with Actual as a column and Colas, Root Beer, and Cream Soda as rows. If the Actual values for these products were 100, 200, and 300, the average would be 200. So the Difference from Average (%) column would be -50, 0, 50.