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 10:14 am

    #1659402

    Daniel Bowlin (10/17/2013)

    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"

    Hi Daniel, my preference was to handle the conversion in the SQL statement itself, but unfortunately I can't as the dataset column is used elsewhere. I could possibly create an additional column but I wanted to see if there was a simpler solution first (more for future use than anything!)