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:

       

      2017-09-22_1115.png

       

      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?

       

      Thanks,

      Mike