Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

multiple conditions with OR

allwynbazil
8 - Asteroid

Team,

 

I am handling two conditions in an If statement and am not getting the expected result. In this case, the count is 3 and the internal comment is "There are no quotable data for this Case Number". This should return "No" only if the internal comments are not either "There are no quotable data for this Case Number" or "It's a Federal deal and doesn't require budgetary quote" and the count is > 0.

 

allwynbazil_0-1683872729763.png

 

Regards,

Alwin

 

2 REPLIES 2
ShankerV
17 - Castor

Hi @allwynbazil 

 

IF [Count]>0 AND ([Internal Comment C]="There are no quotable data for this Case Number" or [Internal Comment C]="It's Federal deal and doesn't require budgetary quote")
THEN "No"
ELSE "Yes"
ENDIF

 

ShankerV_0-1683873400597.png

 

ShankerV_1-1683873414045.png

 

Many thanks

Shanker V

 

Raj
16 - Nebula

IF [Count] > 0 AND NOT ([Internal Comment] = "There are no quotable data for this Case Number" OR [Internal Comment] = "It's a Federal deal and doesn't require budgetary quote") THEN "No" ELSE "Yes" endif

Labels
Top Solution Authors