Calculating Tax Districts

[mpau]

I've been trying to develop a case calculation that will stamp an order with one of 4 tax districts depending on the information given in the order.

The tax rates are: "Out of State", "State", "County" and "City"

I seem to only be able to get 3 districts working at a time, with State and County overriding one another, depending on which line of the calculation I put first. Oddly, if I pull the county calc line line all of the remaining orders (that haven't been claimed/stamped with out of state or city) file under state, though they don't meet the criteria and visa versa. So I know I'm doing something wrong.

The best way I've been able to work this out pulls from a variety of criteria but makes use of Zip codes for county districts only. Check out the calculation below and let me know what you think. Am I totally backwards here? I've tried this calculation a dozen ways now and feel like I'm missing something.

The returned results are working fine for out of state and city. But I'm getting County as a result for all other orders, even when the zip given isn't in the list.

(Since I'm dealing with CA and Los Angeles in particular they are "Out of State" "CA State" "LA County" and "LA City" - I've shortened the zip list for the post, the complete list is much longer than this)

Case ( Shipping State ≠ "CA" ; "Out of State" ;

Shipping State = "CA" and Shipping City = "Los Angeles" ; "LA City Tax" ;

Shipping State = "CA" and Shipping Zip =

"90201" or

"90202" or

"90209" or

"90210" or

"90211" or

"90212" or

"90213" or

"90220" or

"90221" or

"90222" or

"90223" or

"90224" or

"90230" or

"90231" or

"90232" or

"90233" or

"90239" or

"90240" or

"90241" or

"90242" or

"90245" or

"90247" or

"90248" or

"90249" or

"90250" or

"90251" or

"90254" or

"90255" or

"90260" or

"90261" or

"90262" or

"90263" or

"90264" or

"90265" or

"90266" or

"90267" or

"90270" or

"90272" or

"90274" or

"90275" or

"90277" or

"90278" or

"90280" or

"90290" or

"90291" or

"90292" or

"90293" or

"90294" or

"90295" or

"90296" or

"90301" or

"90302" or

"90303" or

"90304" or

"90305" or

"90306" or

"90307" or

"90308" or

"90309" or

"90310" or

"90311" or

"90312" or

"90401" or

"90402" or

"90403" or

"90404" or

"90405" or

"90406" or

"90407" or

"90408" or

"90409" or

"90410" or

"90411" or

"90501" or

"90502" or

"90503" or

"90504" or

"90505" or

"90506" or

"90507" or

"90508" or

"90509" or

"90510" or

"90601" or

"90069" ; "LA County Sales Tax" ;

Shipping State = "CA" ; "CA State Sales Tax"

)

[Fitch]

I'd consider putting the zip codes in their own table, it will make the data much easier to maintain.

That said, the problem with your calc is it needs to look like this:

Shipping Zip = "90201" or

Shipping Zip = "90202" or 

etc

One other thing, you don't need to specify Shipping State = "CA" since you've already established that the state is not CA in the first condition of the calc.

[mpau]

ah, yes. So simple. Thank you! Knew I was missing something.