The problem you are probably having is that when you +/- your credit or debit, one of those values could be null. If it is then the result will be null.
try in your queries:
SUM(ISNULL(Debit, 0) - ISNULL(Credit, 0))
p.s. Try not to double post. This I answered in the newer post.