Margins on a sales report Totaling
I have a table report that shows each of my projects with several columns: Project Name | Total Sell | Total Cost | Total Profit | Margin Each project might have several rows (due to the origina...
Forum Discussion
I keep my changes in a Change Log table and put a table report in the Project form to show the margins on change orders. I then show the original margin , current projected margin (w/changes) and the actual margin. 1 line per project and in a table not a summary report with the average at the bottom. I made sure to put the financial details on one of the first few tabs to keep it simple to find for management when they want to see the details.
This issue was a headache for me as well.
------------------------------
Jason Johnson
------------------------------
This issue was a headache for me as well.
------------------------------
Jason Johnson
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legendbut that does not solve the issue of getting a mathematically correct margin % as a total.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- I would never total my margins. Right now my margin total is 572% but my margin average is 27% which is correct. I now know that our department is hitting the target but am also highlighting any under performing projects whose margin is not meeting goals.
------------------------------
Jason Johnson
------------------------------- You need an overall project table related one to many to a project finance table. Then you can summarize the financials in your project table and get the overall margin using a formula field to divide the summary of profit into the summary of sell.
Take a look at this thread to learn how to set it up if you aren't familiar with relationships and summary fields:
Relationships and Summary Fields
------------------------------
Adam Keever
------------------------------ - MarkShnier__YouIf you check the math you will find that your average margin % is incorrect.
If you have job with a value of $ 1 million and the margin is 20% GP, and you have another job where the margin is 80% and the value of the job is $1,000, then the average margin will be 50%. But in fact the correct Weighted average margin for both jobs combined will be about 20.1%.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
