I have a data report that retrieves fields from a access database and also creates two calculated fields. ex. Sales | Cost| Profit| Margin. In the report footer I use the sum functions to add up the sales, the cost and the profit columns. How can I calculate the margin column. I need to use the sum(Profit) / sum(Sales) but I can't seem to figure this one out. Can you help?
Thanks.