I have a report where I have the details rolled up into totals grouped on invoice dates. If you look at the attachd screen shot it will show you the info I'm detailing here. I have a calculation in the query to take the cost and divide it by sales to give me a percent (column OpPct). What I need to accomplish is to calculate that percentage on the totals section. I have a Total Cost (summed) and a Sales totals (summed) - but every thing i've tried in to calculate these 2 columns to give me a percentage on the totals errors out. I can't sum them using the OpPct column because I want the percentage of the total cost / sales total for the day.
Please let me know how this can be done.