The Value expression for the text box specifies a scope that is not valid for a nested aggregate.

Hi SamCarney,

According to the expression you have provided and it seems you have add the expression to do calculation on the row group level and then you got error when you try to SUM all the row group calculated values to display at the footer, right?

Because you are using the custom code and you haven't provide the snapshot of the report structure, it is hard for us to give a clear solution, could you please try to provide details information according to questions below:

1. The sample data in the table that will display in the report.
2. The snapshot of the report structure you have currently designed
3. The custom code you are using and all related expression that have added.
4. Please provide details information about what is the expect results you want to got after each calculation

Any problem, please feel free to ask.

Regards,
Vicky Liu

---

Vicky Liu
TechNet Community Support