Seems to be a problem with the profit margin percentage calculation

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.