I'm having an issue with calculating an average, min, and max of a calculation field. I have the "Orig" data, and "Updated" data that I'm reporting. I created a field to calculate the % difference like (updated/orig)-1. That worked perfectly but when I try to get the avg, min and max in the footer it does not calculate. It calculates for the "Orig and Updated" columns but not for the column containing the "% difference". Also, when I go from design view to report view I get a popup for the new "average" field in the footer like it's asking for some input data. Sorry, I'm not familiar with coding and rely on the built in functions. The control source for the field in the footer looks like this "=avg([% Dif])". Any help?
# Orig Updated % Dif 1 790 765 -3.2% 2 760 745 -2.0% 3 755 775 2.6% 4 772 750 -2.8% 5 781 769 -1.5% Avg 771.6 760.8 Min 755 745 Max 790 775