Skip to main content
Nintex Community Menu Bar

Formula with two Or and one And not working

  • April 27, 2018
  • 2 replies
  • 7 views

Forum|alt.badge.img+3

This formula is not working for this requirement: only displays if Request Type=Add New Supplier OR =Activate Supplier AND Vendor Confirmation Button=Yes:

 

not(equals(Request_Type, 'Add New Supplier')||(equals(Request_Type, 'Activate Supplier') &&equals(Vendor_Confirmation_Button, 'Yes'))

 

It was working without the part after ‘||’ .  Once I added the 2nd condition after ‘||’, this control is displayed regardless the value in “Vendor Confirmation Button”.

 

It seems that the condition after ‘&&’ is ignored.

 

I also tried this way and it also not working:

 

and(equals(Vendor_Confirmation_Button, 'Yes')), not(equals(Request_Type, 'Add New Supplier')||equals(Request_Type, 'Activate Supplier'))

2 replies

Forum|alt.badge.img+3
  • Author
  • April 27, 2018

I got this to work:

not(or(equals(Request_Type, 'Add New Supplier'), equals(Request_Type, 'Activate Supplier'))&&equals(Vendor_Confirmation_Button, 'Yes'))

It's just matter of enclose components properly, 'Not' negates everything enclosed


Forum|alt.badge.img+16
  • April 29, 2018

Thanks for sharing.