Formula not working

[#1]

Hi,

Can anyone help me to figure this out. I am loading the file, and changing one of the fields in the script

However, created field 'Repeat' only shows '0', even if the was 'No' in the original file.

[Clever_Anjos]

maybe there are some spaces or mistypes, please check

[sunny_talwar · Accepted solution]

What if you try this:

If(Capitalize(Trim(yourField)) = 'Yes', 1, 0) as Repeat

HTH

Best,

Sunny

[fred_s]

Hi Nina,

Don't use as "Repeat" but as Repeat.

And in addition to Clever, besides checking the fieldname, check Yes/No for the exact same use of capitals.

Grtz Fred