title: How to round to the nearest penny?
body: <p>Column GrossCommission displays value 368.760000 but I need it to be 368.75.</p>
  
  <p>Column NetDueCarrier displays value 31.240000 but I need it to be 31.25</p>
  
  <p>Below is the calculation for those values:</p>
  
  <pre><code>SELECT  
          policyNumber, 
          CompanyCommission, 
          CASE WHEN [GrossPremium] &lt; 0 THEN [BondAmount] * (-1) ELSE [BondAmount] END  as [NetPenalLiability],
          GrossPremium as WrittenPremium, 
          PayableFees, 
          (GrossPremium * (CompanyCommissionActual /100)) as GrossCommission, 
          BillDate, 
          PolicyType,
          ((GrossPremium -  (GrossPremium * (CompanyCommissionActual / 100))) + PayableFees) as NetDueCarrier 
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/8jbJU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8jbJU.png" alt="enter image description here"></a></p>