I have 3 fields. Amount, Tax, Total.
The Tax field is a calculation field. It calculates a value based on the number in the Total field (that is, Total/11).
The Amount field is a number field with a calculated value, that is Tax - Total.
I type in the number in the Total field and I get a number in the Amount field the same as the Total field, which is incorrect. If I delete the number in the Amount field (or change it in any way) then the calculation is made correctly.
It seems to me that the Amount calculation is done before the Tax calculation which produces an incorrect result.
How can I fix this? Any ideas?