title: I am getting a 'Sum' is not a recognized built-in function name
body: <p>I am summing a variable. I also want the format of this variable to have the thousand separator in it. I am using the following code and getting the error in the title. any help is appreciated.</p>
  
  <pre><code>SELECT 
  Convert (varchar(10),CAST(Sum(ar.chgamt as Int),1))
  ,Sum(ar.curbal) as CurBal
  FROM rpt_dat_ARDetail ar
  WHERE reportmonth = '06/01/2013' AND uci = 'VIT'
  GROUP BY ar.curbal,ar.chgamt
  </code></pre>