Data Report

[d.paulson]

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.

[Praba S]

Hi,

U can create Profit Margin (sum) by adding a formula field.

1. Add a formula field
2. Enter this formula in the above field
"(Sum ({Table2.Sales}, {Table2.Sales})-Sum ({Table2.Cost}, {Table2.Sales}))/Sum ({Table2.Sales}, {Table2.Sales})"
Here Sales and cost are the respective fields, which u can change.
3. Place the field in the section where other sum are displayed.

Hope this helps
Regards
Praba