mustapha-721538 (9/12/2011)
Thank you for this solution.One issue is solved now I´m displaying 0 instead of NULL in all the columns except the total column it still displays NULL when at least one column is NULL/0 from the set of columns [1][2][3]...
As per my post above:
Also, be careful with your Total column. You need to wrap each one in an ISNULL to prevent one NULL value making the whole calculation NULL.
I did add it 30 seconds or so after the orginal post, so maybe you didn't see it. Anything plus NULL always equals NULL