title: SQL Round Up or No Decimal
body: <p>I have the query</p>
  
  <pre><code>SELECT count(hh.[HouseholdIncome]) CountHH
      ,sum(try_convert(numeric(20), hh.[HouseholdIncome]) ) CountIncome
      ,sum(try_convert(numeric(20), hh.[HouseholdIncome]) ) / count(hh.[HouseholdIncome]) AnnualIncome
  FROM [MergeData].[dbo].[HouseholdIncome] hh
  </code></pre>
  
  <p>I like to have the <code>AnnualIncome</code> result with round up or no decimal.</p>