4 Replies Latest reply on May 1, 2014 7:00 AM by Tyler Pickering

    Change a missing date from NULL to Blank (Or Custom Text)

    Tyler Pickering

      I have a column of "Year of Effective Contracts"--I want to keep the ones that are blank but don't want the ones with no data to say NULL. Is there a way to change this to either blank or "No Contract?"

       

      I came across a formula :

      IFNULL([dimension containing the null literal], ‘string to replace the null literal')

       

      That did not work for me and I'm looking for any other options...

       

      Thanks as always!