Mathematical calculations in the template ticket?

Hello to all. Today I’m in trouble with taxes. :confounded:. It is possible that I can do mathematical calculations in the template ticket?

sorry for the post but could not find how to clear it. I found what I needed.

But I have a problem:
VAT 10% : [=F(TN(‘{TICKET TOTAL}’)*0.1)] €
TOTAL LESS VAT : [=F(TN(‘{TICKET TOTAL}’)*0.1+{TICKET TOTAL})] €
can fix it? the total less tax must subtract 10%

How about [=F(TN('{TICKET TOTAL}')*0.9)] ???

If you have 2 totals you want, one as 10% of the total then the other should be 90% no?

1 Like

No, I need one 10% ,
and one total less 10%…:grimacing:

Which is 90% no? What’s 100% less 10%?

1 Like

[=F(TN(’{TICKET TOTAL}’)-((’{TICKET TOTAL}’)*0.1))]

Not sure if that would work… I’m on my phone… but just in case 90% and 10% doesn’t equal 100% :see_no_evil:

Many different ways to do this, and it can depend on whether or not you have your system set to include Tax in prices or not.

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

[TAXES]
<J00>Tax {TAX NAME} ({TAX RATE}%):| {TAX AMOUNT}

[SERVICES]
<J00>{CALCULATION NAME} ([=F(TN('{CALCULATION AMOUNT}'))]):| {CALCULATION TOTAL}
1 Like

What @QMcKay said lol

no they expected. I would just figure it into the template ticket

Why you make it so complicated? I guess you didn’t setup tax template (still not sure if your {TICKET TOTAL} already have VAT included or not)

VAT = {TICKET TOTAL} * 10%
Total less VAT (Most ppl call Sub Total) = {TICKET TOTAL}
Total (incl VAT, Most ppl call Total) = {TICKET TOTAL} + {TICKET TOTAL} * 10% = {TICKET TOTAL} * 1.10

He hasn’t done that though so this is giving him 110% of his total… that’s why I said to do 90%

The real question for him is {TICKET TOTAL} has tax or no tax.

If tax included in {TICKET TOTAL}
Total less VAT 10% = {TICKET TOTAL} / 1.1
Vat 10% = {TICKET TOTAL} - {TICKET TOTAL} / 1.1

1 Like

I’m pretty sure the ticket total includes the tax that’s why he is doing the 10% from it.

Sorry on phone can’t do scripting lol

That is wrong. I’m not surprise more than 60% of ppl do the wrong thing :wink: actually I should say 80%.

2 Likes

This is … but i need to convert in positive, and *-1 doesnt not work.

Subtotal:|[=F(TN(’{TICKET TOTAL}’)/1.10 -TN(’{TICKET TOTAL}’))]

Did you know, if you set up tax template. You can use {PLAIN TOTAL} as total before tax and {TAX TOTAL} as tax and {TICKET TOTAL} as total incl. tax?

1 Like

Seriously, if you want positive value would you put small amount first then minus bigger amount.
Subtotal:|[=F(TN('{TICKET TOTAL}') - TN('{TICKET TOTAL}')/1.10)]

3 Likes

Mana Thanks :kissing_closed_eyes: