Why won't this Advanced Condition work?

Question

Very simple Condition

Advanced Rule

(Data Label 1 Not equals to MARS or Data Label 1 Not Equals PLUTO)

AND

Data Label 2 Equals Y

Show message "Blocked"

So i pass the following to this expression:

MARS and Y

Result is Message says "Blocked"

WHY? I have brackets around the first two conditions and an OR inside, then AND for the second part.

The expression should fail because i am saying NOT EQUALS....

Are the simplest things so trickly with K2?

Albarghouthy · Accepted Answer

Hi Sharpharp,

In your example the result is TRUE:

(Data Label 1 Not Equals to MARS

OR

Data Label 1 Not Equals to PLUTO)

AND

Data Label 2 Equals Y

Given the data labels value (MARS and Y), the condition will results in the following:

Data Label 1 Not Equals to MARS = False

Data Label 1 Not Equals to PLUTO = True

Data Label 2 Equals Y = True

(False OR True) AND True

Result:

(True) AND True = True

Change OR to AND

Sign up