Skip to main content
Nintex Community Menu Bar
Solved

Why won't this Advanced Condition work?

  • February 19, 2018
  • 1 reply
  • 6 views

Forum|alt.badge.img+16

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?

 

 

Best answer by Albarghouthy

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

1 reply

Albarghouthy
Forum|alt.badge.img+16
  • Scholar
  • Answer
  • February 20, 2018

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