Copy link to clipboard
Copied
Hi all
I am creating an invoice and one of the fields is the form is tax (to be added). How do I add that in the calculate area, if I have a subtotal field and want to add 24% to that total?
Thanks in advance
Rob
OK, I sorted it.
(subtotal*1.24)-subtotal
Thanks for your help!!
Copy link to clipboard
Copied
Multiply the subtotal by 1.24 ...
Copy link to clipboard
Copied
Thanks for that. Can I now ask, where would I put this calculation and in what format to select teh field and then do the multiplication.
Thanks in advance
Rob
Copy link to clipboard
Copied
That depends. Do you want to edit the value of the subtotal field itself, or do you want to show the value of the subtotal+tax in another field?
Copy link to clipboard
Copied
The Subtotal firld is a sum of all the values in the form above, it doesn't get edited.
The tax field also is not editable just a value of subtotal*1.24
Thanks
Rob
Copy link to clipboard
Copied
Enter that formula under the Simple Field Notation option of the Calculate tab of the tax field, then.
Copy link to clipboard
Copied
I found this as an example expression, but it doesn't seem to produce the right result.
{{tax_added:calc(subtotal * 1.24):format(number, “€,.00") }}
Copy link to clipboard
Copied
OK, I found the problem. I did this and it kind of works, but the Total is wrong. The total is simply Subtotal+Tax.
Rob
Copy link to clipboard
Copied
OK, I sorted it.
(subtotal*1.24)-subtotal
Thanks for your help!!
Copy link to clipboard
Copied
Ah, you want just the tax... In that case you can simply multiply by 0.24 .