This content has been marked as final. Show 5 replies
I've read a few posts, as well as the NULL and Nothing paper by Henric, but I'm still unable to achieve what I'd like to do.
Using Sense July 17 Patch 1, I have a table that shows some missing values. From what I've read, I should be able to use IsNull() to test for these, and hopefully fill in a default value. However, IsNull() seems to return null. This table shows an example:
Interestingly, if I unselect "Include null values" for the CP.Ven_Nbr field, the rows with missing values are excluded.
Would like to replace the hyphen with a default value.
Can someone point me in the right direction?