Gross Margin calculation in Access 10 report

[John Donovan]

How do I calculate Gross Margin in a Access 10 Report ?


eg [Sales] total $50000, [CostSales] total $20,000
I am trying to get the report to show a new line [GrossProfit] $30,000
Taking the report a bit further
[Expenses] total $10,000
I wish the report to show...[NetProfit] $20,000

Thanks
John D

[Bob Fitz]

Gross Margin
[GrossProfit] / [Sales] * 100

[pbaldy]

The following was submitted as a reported post, presumably meant to be a reply:

Thanks Bob
However your response appears to provide the formula for a gross margin percentage on sales.
In my report, I am trying to place a formula somewhere in the report (footer?) where the total cost of sales are deducted from the total revenue..
eg in another very simple example...
my report shows many lines of [Revenue] which I can see on screen totalling $100,000
the same applies to many lines of [Cost of sales], which total $40,000
What is the formula to place (and where do I place it), for the report to show on the next line showing
[ Gross Margin] $60,000
I DO NOT wish to see the Gross Margin of 60%
and further...
If ]Overheads] total say $20,000, what is the formula to show [Net Profit] $40,000 on the bottom line, and where do I place this formula in the report.


Thanks a lot Bob

[Bob Fitz]

Can you post a copy of the db in A2003 mdb format.