3 Replies Latest reply on Mar 3, 2017 3:47 AM by aftab.najib

    Replace Null values with 0 for each week

    aftab.najib

      Hi, I am trying to workout how I can show 0 values in a table that shows me the student name and the week ending date across the top (attached image).

       

      I have managed to write the following formula:

       

      IF ISNULL((SUM([SCORE]))) THEN 0 ELSE (SUM([SCORE])) END
      

       

      but this has added the 0 values in an extra column next to the dates rather than within the dates and I am not sure how to do this.

       

      Would appreciate some advice on how I can get this fixed.