5 Replies Latest reply: Sep 25, 2017 8:29 AM by Mike Hildner RSS

    Fill in Missing Values

    Mike Hildner

      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?