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 8:13 am

    #1659338

    I would try using the decimal conversion on only the numeric values.

    =AVG(IIf(Fields!SCORE.Value = "Unknown", Nothing, CDec(Fields!SCORE.Value)))

    I think converting "Nothing" to a decimal creates the zeroes that are causing the problems.