Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Writing Conditional IF/OR/AND

Inactive User
Not applicable

Having trouble converting conditional excel formulas into Alteryx syntax. Essentially I want to create a statement which reads IF X OR Y is TRUE then YES else NO. Note X and Y are themselves conditional AND statements.

 

In excel this would read IF(OR(AND(Y="0", Balance1<>0),AND(Y="0",Balance2<>0)),"Yes","No").

 

Any help would be appreciated! For some reason this board is not allowing me to upload my workflow, but formula reads as below in current state.

 

 

3 REPLIES 3
Garrett
11 - Bolide

IF ([PRODUCT] = "0" AND [AIR Balance] != 0) OR ([PRODUCT] = "0" AND [AIP Balance] != 0)

          Then "Yes"

Else "No" EndIf

 

 

AlteryxUserFL
11 - Bolide

Hello, 

 

Here is an example:

 

 IF ([Incremental Change Flag] = "1" OR [Two Touch Flag] = "1" OR [Signature Amount Flag] = "1") And [Incremental Change (USD)] > 299999 THEN "SOX"
ELSEIF [Incremental Change (USD)] > 99999 THEN "Operational 100k"
ELSE "Other"
ENDIF

 

 

Here is your example: 

 

IF ([y] = "0" and [Balance1] != "0") or ([y]="0" and [Balance1] != "0") then "YES" else "No" ENDIF

 

Inactive User
Not applicable

thanks that did it!

Labels