Better way for conditional calculations?
In my work order database I have a field for sales tax. Since I do a lot of wholesale work, out of state work, and exempt work I made this field a conditional calculation based upon the the selected repair billing type. This is selected from a value list of 5 entries, of which the only to get taxed is "Retail".
I have the tax field set up to be auto entered as a calculated value using the following formula
If ( Repair Type = "Retail" ; Repair total * .0875 ; 0 )
The issue I am having is if I have the Type field set as Retail but then change it to another value from the list the value in the Tax field does not change.
Is the formula I have chosen to use the issue (is there a "better" way) or am I just missing a check box someplace that is preventing it from behaving properly?