In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Conditional IF and OR Statement Help Needed

kubikbr
6 - Meteoroid

Looking to write a conditional formula to tag the data in the attached workbook. The On Call column is what I am trying to write in Alteyx for it to auto tag, but can't seem to get it right.

 

Essentially if [TotalPayableHours]=1 AND ([TotalPayableAmount]=100 or [TotalPayableAmount]=250) THEN "Yes" ELSE "" EndIF

1 REPLY 1
binu_acs
21 - Polaris

@kubikbr 

 

IF [TotalPayableHours] = 1 AND ([TotalPayableamount] IN (100,250)) Then 'Yes' Else Null() EndIF

image.png

 

Labels
Top Solution Authors