AnsweredAssumed Answered

incorrect calculation

Question asked by zifbox on May 9, 2009
Latest reply on May 10, 2009 by zifbox


incorrect calculation



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?