Copy link to clipboard
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).
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.
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.
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?
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.
Don't use the calculation at the dropdown.