I am running a quarterly report - the report sums revenue and sums goal and % over/under goal by each period. I have the quarterly amounts totals for both revenue and goals working in the footer but when I try to get % for quarter I just get the total of each period % not the correct % for the quarter. If I remove sum function, i just get the last period %.