Change discount calculation

Change discount calculation

Hello Zoho team and others,

I tought I finally managed to create my perfect invoice template when I realise that one operation isn't right.

The problem comes from a specific discount in the total. It's a discount that will just influence the VAT and NOT the Grand Total. I show you with an example, that will be more easy to understand.

my sub total excl VAT is            1000 €
My "specal" discount is 2% ==> 20 €
So my VAT(21%) will be:  (1000-20) * 0.21 = 205.8 €

Up to that, there is no problem. But then comes the tricky part to calcul the Grand Total.

For my needs, the calcul must be:   1000 € + 205.8  € = 1205.8 €
And not    (1000-20) + 205.8 = 1185.8 €


Is there any way I can fix that? I tried to look after but i didn't find an answer.

 Please, right me back as soon as possible.