total average of a text box

Hi Anu,

Per my understanding that you have add an group "Branch_Name" in the report and you can using the expression "=Avg(Fields!YTD_Total_Premium.Value,"Branch_Name")" to calculate the average value for each group, now you want to get the total average value based on all the "Branch_Name", right?

I have tested on my local environment and it is easy to get the total avg by using the expression "Avg(Fields!YTD_Total_Premium.Value,"DataSetName")"

Details information below for your reference:

1. Right click the Group "Branch_Name" under the row group and select the "Add Total" and click "After"
   
   


2. Add or modify the expression to get the value of Total Average:
   
   Avg(Fields!YTD_Total_Premium.Value,"DataSetName"
   
   

If your problem still exists, please try to provide your report structrue and the sample data.

Any problem, please feel free to ask.

Regards

Vicky Liu