Alteryx Designer Desktop Discussions

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

Multiple OR Statements for Formula field

MyriamB
7 - Meteor

Hello

 

Below is what I would like to get to return 1 or 0 counts

 

I tried

 

IIF([Application] ="Salesforce1 for iOS" OR "Salesforce for iOS" OR "Salesforce1 for Android" OR "Salesforce for Android",1,0)

 

while there are record meeting criteria, I keep getting 0 -

 

What formula  should I use?

per below Not seeing errors when I write it

 

Any suggestions?

thank you

 

Mobile.JPG

 

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
Here’s another approach:

IIF([Application] IN ("Salesforce1 for iOS" , "Salesforce for iOS" , "Salesforce1 for Android" , "Salesforce for Android"),1,0)

Cheers,
Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
MyriamB
7 - Meteor

Thank you!  @MarqueeCrew 

Labels