itmasterw 60042 wrote:
Thanks for the reply, but that is not what I need.
I need a way to write this that when the state is MN then these ProcCodes are Excluded, but in any other state then they are good.
Do you know how AI can write that?
Your responses show that you are not bothering to read the suggestions and figure out how they work. My response does EXACTLY what you asked for, it's just evaluated in a slightly different order.
WHEN MyState <> 'MN' THEN 1 -- "in any other state then they are good"
WHEN ProcCode NOT IN ('Kl', 'Kjh') THEN 1 -- we know MyState = 'MN' in order to get to this point and this includes every ProcCode except the ones you want to exclude.
ELSE 0 -- we know that MyState = 'MN' and ProcCode in ('Kl', 'Kjh') to get to this point, and "these ProcCodes are Excluded"
You had a very similar response to Jonathan AC Roberts.
If you expect us to put in the work to help you, then you need to demonstrate that you are also willing to put in the work, and you clearly are showing that you're not willing to put in the work.
J. Drew Allen
Business Intelligence Analyst