# Show total price before tax

hi all, i have problem with the bill print, in the invoice just show the tax and total price + tax, but not shown the price before tax…

Dont know if there is a tag for ‘NET’ price or not as dont use the tax system in samba however you can use a formula to take the tax from total to give a net rate…

You can use something like this:

``````<J00>Subtotal:|[=F(TN('{TICKET TOTAL}')-TN('{TAX TOTAL}'))]
{TAXES}
<J00>Tax Total:|{TAX TOTAL}
<J10>TOTAL:|{TICKET TOTAL}
``````

@QMcKay
Without changing the subject completely, if you were not using the samba tax settings and wanted to show VAT breakdown would the following work?

Net: [=F(TN(’{TICKET TOTAL}’) / 1.2 ]
Tax: [=F(TN(’{TICKET TOTAL}’) / 6 ]
Total: {TICKET TOTAL}

Yes, but missing bracket:

``````Net: [=F(TN('{TICKET TOTAL}') / 1.2)]
Tax: [=F(TN('{TICKET TOTAL}') / 6)]
Total: {TICKET TOTAL}
``````
1 Like

Is there likely to be any rounding issues doing this way? only going to be 1p if there are I guess.
Will TN format it to 0.00 or do I need to specify formatting?

to round to 2 decimal places add this to your expression `,'0.00'`

for example;

``[=F(TN('{TICKET TOTAL}'),'0.00' )/ 6]``

Would you not need to put the formatting outside of the calculation as its the deciding by six if where the additional decimal places would come from.
Would a second TN function be required outside of the =F ?

1 Like

Sorry my bad it should be

``````[=F(TN('{TICKET TOTAL}')/ 6),'0.00']
``````

that works for me

1 Like

although for me to display 2 instead of 2.00 i have to use the first example i posted but i put ,‘0’ instead of ,‘0.00’ if i try and put ,‘0’ at the end it doesnt work and still show 2.00