Alteryx Designer Discussions

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

Conditional Insert more than one string

IvanMtz
5 - Atom

Hello Alteryx Community 

 

I have a problem with conditionals I'm trying to do a formula but it doesn't do what I need it to do and I'm thinking that my syntax is wrong here it is

 

IF [Expense Type]=='Hotel' and [Expense Area Name]IN('Phoenix','Scottsdale','Monterey','Napa') and [Overage]=='Yes' THEN ([Reimbursement Amount] - 195) ELSE 0 ENDIF

 

But in the column, it doesn't do the subtraction 

 

Could you please help me and is correct to use IN to search for more than one string? 

 

Thank you for all your help

4 REPLIES 4
atcodedog05
20 - Arcturus

Hi @IvanMtz 

 

Your does look correct. Can you share some sample data so that we can take a look into it.

atcodedog05
20 - Arcturus

Hi @IvanMtz 

 

Here is an example your formula is working. 

 

Workflow:

atcodedog05_0-1631208155884.png

Please check your incoming data make sure they are same dont have spaces.

 

Hope this helps : )

 

IvanMtz
5 - Atom

Thank you so much for your help 

 

atcodedog05
20 - Arcturus

Happy to help : ) @IvanMtz 

Cheers and have a nice day!

Labels