SOLVED
Formula tool not working for my If formula for a string value
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JonaV
8 - Asteroid
‎11-04-2020
08:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
11 REPLIES 11
‎11-04-2020
09:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That was it! There were white spaces in the EP_Scenario, so I used a Data Cleansing tool
Thanks
22 - Nova
‎11-04-2020
09:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
😂😂
Anyways glad to hear it got solved 🙂
Happy to help 🙂
Cheers and Happy Analyzing 😀

- « Previous
-
- 1
- 2
- Next »