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



      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