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.
Solved! Go to Solution.
IF ([PRODUCT] = "0" AND [AIR Balance] != 0) OR ([PRODUCT] = "0" AND [AIP Balance] != 0)
Then "Yes"
Else "No" EndIf
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
thanks that did it!