Hi all - just started using AppSheet, and pulling my hair out about an problem:
I have create an invoice form that has a field called “Invoice VAT.” This is set up as a Decimal, and should be calculated based on a VAT Rate (which is a percentage referenced from another table) and a Total Amount, which is a Number entered in the form by a user…
My problem is that the “Invoice VAT” field will not show a Decimal. For instance, if the actual amount should be 2.50, the “Invoice VAT” field shows 3. If the actual amount is 0.35, the “Invoice VAT” field shows 1.
Just to double-check, I set the “Invoice VAT” field to equal whatever the user selects from the VAT Rate dropdown, but it still doesn’t show the decimal. If the User selected 21% from the VAT Rate drop-down, the “Invoice VAT” shows 1.00.
I really cannot figure out what is going on here.
For reference, for the “Invoice VAT” I have the following Type Details set up:
Numeric Digits: 2
Maximum Value: blank
Minimum Value: blank
Increase/decrease step: blank
Decimal digits: 2
Thanks in advance!