I have a report that has a column that takes the differnce between column A and column B. The expression is written to put a zero in the case that there is a negative number. The expression looks like this:
=IIF(Fields!User_Define_1.Value - Fields!Act_Labor_Units_TTD.Value >0, Fields!User_Define_1.Value - Fields!Act_Labor_Units_TTD.Value, 0 )
User_Define_1 is column A
Act_Labor_Units_TTD is column B
The above formula is in column C
There is a row I would like to add a total for the group. The group name is "table1_FRSTNAME"
I tried to put in a formula that using SUM(ReportItems!textbox30.value) but it said I can only use that in headers and footers.
What should I put in th expression editor to total column C for each group?