Formula tool not working for my If formula for a string value

[JonaV]

Hi,

I would appreciate some help on this issue

I have a formula as follows

Event Year (field nam)

IF [EP_Scenario]="2019Actuals" THEN "2019" ELSE IF [EP_Scenario]="2020Actuals" THEN "2020" ELSE "" ENDIF ENDIF

However, when I run the workflow and check the data in the Event year field there are blanks instead of the 2019 and 2020 years that I specified in the formula. Does anybody why this is happenning?

Thank you,

JV

[JonaV]

That was it! There were white spaces in the EP_Scenario, so I used a Data Cleansing tool

Thanks

[atcodedog05]

😂😂

Anyways glad to hear it got solved 🙂

Happy to help 🙂

Cheers and Happy Analyzing 😀