If statment returning Null
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I have the following formula that is returning some Null Values. I exported into excel the Output data and looked at the items with STTL_STATUS of "5". About 95% of them returned a value but about 5% returned Null. I can't figure out why since the STTL_STATUS field has been cleared of whitespace, all values looked at = "5" exactly, and the [STTL_DATE] field has a value for every entry including the ones that are returning Null that is data formatted and also cleared of whitespace.
Can you think of any reason why a small subset of the output data would be returning a Null value? Thank you
if [STTL_STATUS] = "5" then [STTL_DATE] elseif [STTL_STATUS] = "4" then [STTL_APP_DATE] elseif [STTL_STATUS] = "2" and [STTL_ORDER_SUFFIX] = "POA" then [STTL_DATE] elseif [STTL_STATUS] = "2" and [STTL_ALREADY_APPLIED] = "1" then [STTL_DATE] else "Unapplied" endif
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Jon12 ,
Since you have an 'else' condition, everything with no match will end there, so the only thing I can think of is that [STTL_DATE] or [STTL_APP_DATE] have null values.
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are all of the fields strings? If one of them is a date this could be leading to your error.
If you post some sample data and a screen grab of a select tool prior to the formula for type verification I'm sure someone can quickly solve it.
