Page 1 of 1

Invoice Product profit report

Posted: 22 Jan 2018, 20:35
by Rupert E
Hi,
I'm trying to re-design my invoice product profit report to actually show the profit as a percentage. It currently just shows the actual amount of profit
in £'s. It would make it a lot easier when glancing down a list if it showed a % and so show up errors/low margins. I've tried searching for the correct data field but not had any luck so far. It may not be possible but wonder if anybody has any ideas?
Thanks

Re: Invoice Product profit report

Posted: 23 Jan 2018, 16:55
by brucedenney
You need to add an expression field.

In the expression editor you then want to Divide the Profit Amount by the Sale Amount to get profit as a %ge of Sales.