Conditional Insert more than one string

[IvanMtz]

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

[atcodedog05]

Hi @IvanMtz 

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

[atcodedog05 · Accepted solution]

Hi @IvanMtz 

Here is an example your formula is working. 

Workflow:

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

Hope this helps : )

[IvanMtz]

Thank you so much for your help 

[atcodedog05]

Happy to help : ) @IvanMtz 

Cheers and have a nice day!