Formula Tool

Question

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 Answer

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 Answer

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