Stil not showing up, would this have anything to do with ANSI settings within Management Studio.

From what i've read and tried the ISNULL(COUNT(*), 0) AS 'Count' should resolve this but that 0 field still won't appear so was wondering if it wa elsewhere?!?