Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors