1 Reply Latest reply on Jan 5, 2017 3:41 PM by Shinichiro Murakami

    Nulls and Dates - How do I turn nulls into 0's

    alex lewis

      Hi,

       

      I am trying to create a calendar view of my data. I do not have data for every day of the month, therefore I am left with numerous blank spaces.

       

      I want every day of the month to appear, but instead of blanks, I want 0's to appear.

       

      Undoubtedly some conditional formatting is required. I tried ifnull ([measure]),0 however, this confuses matters.

       

      Below is a shot of what I currently have;

       

      Please help

       

      Thanks

      Alex