Continuing the discussion from Custom Report P&L profit and loss:
1 Like
It looks like QmcKay made a typo in the formulas, throughout the reports.
To calculate the profit margin it should be Profit ($4 in the report) minus Cost ($5) divided by Profit ($4). He has it as Profit ($4) minus Cost ($5) divided by Quantity ($3). You can find the $x by counting the columns. The first report should be [($4-$5)/$4];#0.00 %;-#0.00 %,
He does have in some of the titles a || and in the report section he has '', count those as columns.
That should be enough information to fix the rest of the reports.
2 Likes