Incorrect subtotals on report

[leahb747]

Hi everyone.

I have a report that shows the costs incurred by resources on particular projects. The report is firstly grouped at the project level, and then at the resource level.

Each resource is classified as either Plant or Labour, and the costs incurred (based on this split) are listed to the right hand side. These formulae are now working, however, I need a line below each project level, that totals all the resources working on that particular project. At this stage I'm getting numbers from all over the place and I can't work out what it's actually calling on.

The formula I'm using for the calculation of the plant resources costs is, =IIf([LabPlant]="Plant",0,[Cost])

[LabPlant] has been selected at a prior stage, and the Cost is in the query.

I'm then trying to work out (say if I have three resources in a particular project) how to sum all the results of this formula.

I've tried creating a query item ToDateLabPlant : IIIf([LabPlant]="Plant",0,[Cost]) and using a control to replace the formula on the report. And then using =Sum([ToDateLabPlant]) in the control to get the total to no avail. Any help would be greatly appreciated. TIA

 

[vbaInet]

Something like this:

=Sum(IIf([LabPlant]="Plant", [Cost], Null))

... that's for costs related to plant.