Report returns #Error when attempting to use the Average function in SSRS (Avg())

Version 1

    Details

    When running a report build in SSRS, the report returns #Error when attempting to use the Average function, Avg().


    Resolution

    The field type used in the calculation can also cause issues if they are not numeric.  You can cast the entire set as a specific type by using the function CInt()  =Avg(CInt(Fields!.Value))