Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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