Thank you so much for this excellent solution. I just encountered the "zero in the Course Totals field" yesterday after removing a column calculation I had created. I looked high and low for the cause and solution. Just this morning, I came across your post - and this was exactly what was needed.
Best wishes for the holiday and the new year.