title: Count Returning blank instead of 0
body: <p>Good day everyone. Here is my code:</p>
  <pre><code>SELECT 
      'Expired Item -'+ DateName(mm,DATEADD(MM,4,AE.fld_LOAN)) as [Month]
      ,COUNT(PIT.fld_ID)'COUNT'
      ,SUM (PIT.fld_GRAM)'GRAMS'
      ,SUM (PH.fld_AMNT)'PRINCIPAL'
  FROM  #AllExpired AE
      INNER JOIN Transactions.tbl_ITEM PIT
      ON AE.fld_MAINID=PIT.fld_MAINID
      INNER JOIN Transactions.tbl_HISTO PH
      ON AE.fld_MAINID =PH.fld_MAINID
  GROUP BY DATENAME(MM,(DATEADD(MM,4,AE.fld_LOAN)))
  </code></pre>
  <p>The problem I'm facing is that my <strong>Count</strong> function does not return 0 if it has no values, <strong>Sum</strong> function does not return NULL if there are no resulting values retrieved. Instead, it just outputs blank. Why is that so and how can I fix it?</p>
  <p>Here is a screenshot of sample output.</p>
  <p><img src="https://i.stack.imgur.com/P372V.png" alt="A" /></p>
  <p>Of course this is not what I want. I want it to output zero and null. Please help me, I do not know what's wrong. Thank you.</p>