SOLVED
Another pair of eyes on a simple If Then Statement
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
mattlukoff
8 - Asteroid
‎05-21-2017
12:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, can anyone take a look at this. Not understanding why I'm not getting the desired output.
Thanks
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
2 REPLIES 2
Joe_Mako
12 - Quasar
‎05-21-2017
12:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Federica_FF
11 - Bolide
‎05-21-2017
12:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I think you may want to remove the exclamation point.
Right now you're telling the formula tool:
IF !ISNull([Key 1]) then [Right Key 1]
// if NOT is null Key1 then Right Key
Else Null()
// else Null()
ENDIF
Key1 is actually null, so you're getting the "else" part of your IF statement.
![](/skins/images/9780FA8738778E76CAA545EFAA4CDA4D/responsive_peak/images/icon_anonymous_message.png)