Report summary problem

[RussG]

Hi - little bit of assistance needed.

I have a report that groups on Dept then ChargeCode then Codegroup. I have sub totals for each Chargecode.

Because 'Labour' is charged separately I want to have a total for all 'Labour' costs which are then deducted off the grand total i.e.

Total of everything £1000.00
Less Total of Labour £ 50.00 (txtCGrpTot)
SUM = Total less labour £ 950.00

I tried this:
=IIf([CodeGroup]="Labour",[txtCGrpTot],0)
But it is only picking up the total Labour charge for one charge code.

What I need is something like:
=IIf([CodeGroup]="Labour",Sum([txtCGrpTot],0))

i.e. total up all the Chargecode subtotals where the CodeGroup = "Labour".

Any help would be greatly appreciated.

Thanks
RussG

 

[RussG]

Sorted this - changed my grouping order which solved the problem.
Thanks
RussG