Formula Tool

[Stacy]

Hi, 

I tried to add a formula tool with expression below.

iif(length([GCLID])>50 and ([Score])>3,"Y","N")

What i trying to do is find field "Gclid" string length >50 and field "score" number >3 to mark with Y in the new output field and other with N in the new output field. But it doesn't work. Please help. Thank you!

Stacy

[kevinbird15 · Accepted solution]

Hey Stacy,

What type are you making the new field?  For a "Y" and "N", it will have to be String or similar type.  If that isn't the problem, what is the error that you get when you put that into a formula?

Thanks, 

Kevin

[MarqueeCrew · Accepted solution]

If there are trailing spaces on the text, you might want to use the TRIM() function. @kevinbird15 is right in that your new variable needs to be a string to accommodate the Y/N values. You could also make it Boolean and use 1&0 values. 

Thanks,

Mark

[Stacy]

Thank you Kevin. I got it! I didn't change the string type. Thanks for the help!