Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
A belief is not merely an idea that the mind possesses, it is an idea that possesses the mind
R. Bolton
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Calculate Averages in SQL Server Reporting Services?

During a recent SQL Server Reporting Services report writing project i noticed the the in-built SSRS Avg function returned the incorrect value when calculating the average time differences for a sub group.


To work around this I had to create the following custom formula:
=SUM(MAX(Fields!Field_Name.Value, "Group2_Name"),  "Group1_Name")/COUNTDISTINCT(Fields!Field_Name.Value, "Group1_Name")

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


Name *

Email Address *

Comment *

To prove you are human what is:

74 + 31 =