AnsweredAssumed Answered

Better way for conditional calculations?

Question asked by JeffDening on Feb 8, 2011
Latest reply on Feb 8, 2011 by philmodjunk


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?