1 Reply Latest reply on Jan 22, 2014 4:32 AM by Jim Wahl

    Remove Null Value from Date Dimension

    Barry Crane

      Hi all

       

      I have put together an orders report and one of the dimensions is broadcast date. Some of my orders do not have a broadcast date so the these show 'null' how can I update this to show a blank.

      The below worked on some text but not on a date:

       

      IFNULL([Broadcast Date], '')

       

      Barry