Can you set multiple values in a dropdown to calculate different tax percentages?

[S15B9]

Hi, I'm building a form that needs to calculate muliple percentages in a dropdown. I have an amount field called "AMOUNTRow1" a Dropdown field that should calculate different percentages and a total field called "TOTALRow1" (Example if the amount field says $20 I want to use the dropdown to get the tax percentage of 6.25%, 8.5% or 8.25%, and then have the total amount in $$. I'm not familar with custom javascript calculations. Is this even possible to give one cell muliple values?

[try67]

With a drop-down field it is, yes. You can set the export value of each item in it to a different number, and then just multiply it by the value of the Amount text field. For example, for "6.25%" set the export value to "0.0625" (without the quotes).

[S15B9]

I gave each dropdown it's respective decimal value and told it to muliply that number with Amount text field, but it only calculated one.  It will just calculate the first multiplication, which is the 6.25. When I click the 8.5 in the dropdown it still gives me the 6.25% calculation.

 

[try67]

You have to set these values under the Options tab, and then use the Calculate tab of another field to multiply the drop-down field by the amount text field.

[S15B9]

Okay, the values are set in the options tab. In the simplified field notation, I have it as AMOUNTRow1*Dropdown1, which worked until I went to the next row and typed a number in and the Tax field above it changed to 34.00?? Why?

 

[try67 · Accepted solution]

Again, the calculation needs to take place in another field, the Total one in this case.

Also, if you want the total to display the amount plus the tax then you need to set the export value of the "6.25%" item in the drop-down to 1.0625, instead of 0.0625, for example.

[Bernd Alheit · Accepted solution]

Don't use the calculation at the dropdown.