Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago

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...
Relationships
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
but 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
------------------------------
JasonJohnson2's avatar
JasonJohnson2
Qrew Cadet
6 years ago
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
------------------------------
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    6 years ago
    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__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    If 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
    ------------------------------