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.