SSRS report average function

Hi Expert,

I have a student report which have studentID, CourseID and Grade, I grouped by studentID and totaled Grade by each studentID and how I can get average Grade? How I can calculator how many course by StudentID?

Thanks in advance
Who is Participating?
Mark WillsConnect With a Mentor Topic AdvisorCommented:
You can use calculated fields.

There is a good Article :

And while it is not exactly what you wand, it does show averages / totals / and using calculated fields to help build those aggregations.
Were you able to fix your report? Do you need any other help?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.