Home Forums Reporting Services Reporting Services 2008 Development Convert String to Int or Decimal Then Average RE: Convert String to Int or Decimal Then Average

  • October 17, 2013 at 7:59 am

    #1659333

    I would probably use AVG and the OVER clause in TSQL to work this one out.

    http://technet.microsoft.com/en-us/library/ms189461.aspx

    Look at the examples under "Using the OVER clause with aggregate functions"