Trying to show Subtotal for calculated field in report (1 Viewer)

Hi,
I have a Report with Planned Hours and Actual Hours fields that is grouped by Project and then Discipline.
In the Discipline Footer I have text boxes that show the totals for Planned Hours , with formula =Sum([PHours]), and Actual Hours, with formula =Sum([AHours]).
I also have another textbox (Text33) which adds the results from the other two, with formula =[Sum Of PHours]+[Sum Of AHours].

In the Project Footer I have text boxes that show a total for each project. This works fine for the PHours and AHours , with formulas =Sum([PHours]) and =Sum([AHours]). The problem I am having is trying to get the total for the combined values of PHours and AHours. I have tried =[Sum Of PHours]+[Sum Of AHours] but it doesn’t give the correct results.
How can I show a sub total for totals that are derived from a calculated field like this?
Thanks very much
Dave

David Ball said:

.. I have tried =[Sum Of PHours]+[Sum Of AHours] but it doesn’t give the correct results.

Click to expand...

What result does it give then?
Is [Sum Of PHours] and [Sum Of AHours] the name of the controls for Sum([PHours]) and Sum([AHours])?

Does it always give the wrong answer or just when one of PHours or AHours is blank?

If the latter, try using

It is grouped first by Project and then Discipline. Not every project has the same number of disciplines (Electrical, Mechanical, Painter, etc). Whichever discipline is last (at the bottom) the value for that discipline for PHours plus AHours shows up in the Subtotal text box, not the sum for all disciplines.
I can't just add the Subtotals for AHours and PHours because I only want results where there was a value for both and this is not always the case.

It is grouped first by Project and then Discipline. Not every project has the same number of disciplines (Electrical, Mechanical, Painter, etc). Whichever discipline is last (at the bottom) the value for that discipline for PHours plus AHours shows up in the Subtotal text box, not the sum for all disciplines.

Click to expand...

I don't understand how summing the disciplines in the Project group only sums the last named discipline in that group.
I suggest you check how this group has been summed as it shouldn't work that way.

I can't just add the Subtotals for AHours and PHours because I only want results where there was a value for both and this is not always the case.

Click to expand...

That's exactly the reason why I posted this last time:

It will give a total for those items with a cost avoiding null errors
If there are no costs for PHours or for AHours, the formula gives 0 for that group (or zero overall if no costs for either group)

Hopefully the above info will give you enough to complete this task yourself.
If not, suggest you post a sample database with example data to allow someone to help you further