Calculation using GroupFooter1 sum

[Pat]

I am trying to get a calculation in a report which was created using the report wizard that included 2 groups with sums. The calculation I need is the TotalEstProjectHrs minus the SumofExpr1 from the GroupFooter1. The problem that I have is that there are 2 SumofExpr1, since there were 2 group sums. I do not know how to add the fact that I need the sum from the GroupFooter1 to do the calculation. I tried the following- I obvoiusly have no idea what I am doing! I keep telling myself I am not a programmer!!
=([TotalEstProjectHrs])-(GroupFooter1([SumOfExpr1]))

 

[Laney]

Same here !

I'm trying to do close to the same thing. Hope you find out what to do heheheh ... I'll probably post on mine here in a bit.

Good luck!

 

[Laney]

heh well ...

I just got tired of not knowing so I looked it up ... finally found out how to do what I was trying to do ... Now I just need to figure out how to sum the totals for my regular and overtime totals in a week at a time totals. Figured out by day per employee ... just need to get the weekly totals for regular and overtime.