• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Stupid maths question for beginner in field.

Participant ,
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

657

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

Participant , Apr 10, 2021 Apr 10, 2021

OK, I sorted it.

(subtotal*1.24)-subtotal

 

Thanks for your help!!

Votes

Translate

Translate
Community Expert ,
Apr 10, 2021 Apr 10, 2021

Copy link to clipboard

Copied

Multiply the subtotal by 1.24 ...

Votes

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
Participant ,
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

Votes

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
Community Expert ,
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?

Votes

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
Participant ,
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

Votes

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
Community Expert ,
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.

Votes

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
Participant ,
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

Votes

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
Participant ,
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

Votes

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
Participant ,
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

Votes

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
Community Expert ,
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 .

Votes

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