If/and/then statement with parce error char(0)

Hello,

I'm pretty new to Alteryx and I'm not quite sure what i'm doing wrong here.

All the reference columns are data type V-string and I want my output to be a string as well. All the other posts I viewed this error was due to the data type not being formatted as a number/float, but I'm only working with strings here and would like to return a string, so I'm not sure if I need to use an entirely different formula or not.

What I would like to see is "if the RepName column contains test and the Client name column contains test then the In/Out column should return out, else return In"

Alteryx workflow parce error.PNG

Datasets

Accepted answers

MarqueeCrew

@Kumasan77 ,

At some point in time, you created a 2nd expression in your formula tool. Alteryx allows you to make many expressions. You're on your way to learning. The 2nd expression is "collapsed". If you press the > button, you'll expand it. But also, off to the right is a 🗑 trash icon. You can DELETE the 2nd formula expression. Once you do that, you'll be running.