Accpac2010
Programmer
Hi all,
I am trying to build a query that calculate gross margin.
The GM = (revenue-cost)/Revenue
The issue is the revenue and cost are in same table but different record.
e.g. table 1
account type amount
1001 revenue 1000000
1001 Cost 500000
so I need to calculate GM = (1000000-500000)/1000000
Any thoughts,
Thanks
I am trying to build a query that calculate gross margin.
The GM = (revenue-cost)/Revenue
The issue is the revenue and cost are in same table but different record.
e.g. table 1
account type amount
1001 revenue 1000000
1001 Cost 500000
so I need to calculate GM = (1000000-500000)/1000000
Any thoughts,
Thanks