Stupid maths question for beginner in field.

Explorer ,
Apr 10, 2021 Apr 10, 2021

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

practice safe design | use a concept ~ Petrula Vrontikis
TOPICS
How to

Views

193

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct Answer

Explorer , Apr 10, 2021 Apr 10, 2021
OK, I sorted it.(subtotal*1.24)-subtotal Thanks for your help!!

Likes

Translate

Translate
Adobe Community Professional ,
Apr 10, 2021 Apr 10, 2021

Copy link to clipboard

Copied

Multiply the subtotal by 1.24 ...

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Apr 10, 2021 Apr 10, 2021

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

practice safe design | use a concept ~ Petrula Vrontikis

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Apr 10, 2021 Apr 10, 2021

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?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Apr 10, 2021 Apr 10, 2021

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

practice safe design | use a concept ~ Petrula Vrontikis

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Apr 10, 2021 Apr 10, 2021

Copy link to clipboard

Copied

Enter that formula under the Simple Field Notation option of the Calculate tab of the tax field, then.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Apr 10, 2021 Apr 10, 2021

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") }}

practice safe design | use a concept ~ Petrula Vrontikis

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Apr 10, 2021 Apr 10, 2021

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

Screenshot 2021-04-10 at 2.04.12 PM.png

practice safe design | use a concept ~ Petrula Vrontikis

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Apr 10, 2021 Apr 10, 2021

Copy link to clipboard

Copied

OK, I sorted it.

(subtotal*1.24)-subtotal

 

Thanks for your help!!

practice safe design | use a concept ~ Petrula Vrontikis

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Apr 10, 2021 Apr 10, 2021

Copy link to clipboard

Copied

LATEST

Ah, you want just the tax... In that case you can simply multiply by 0.24 .

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines