I have the following problem and i can't seem to find a working solution.
I have ID's that can have 4 different states, lets say, A , B, C and D. (this clasification is working)
An ID can be in state B or C or D (that is working) but for state A, it must be in state A and at least one of B, C or D, depending on the condition for different states, but can't be in state A alone.
Any ideas? I tried different IF and CASE expressions but can't make it work.