David Ball
Registered User.
- Local time
- Today, 23:42
- Joined
- Aug 9, 2010
- Messages
- 230
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
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