Summing a Control 1

[traycee]

Hi All,
I have a control on a report in the program footer which is

=IIf([Program]="MATX",0,(([ActualStaffTime]/[NoMatxTotal])*[MATXHours]))

and it works just fine. However, I would like to sum the numbers it puts across from each program and get a total in the Worker's footer. Sooo...I've tried different variations of

=Sum(IIf([Program]="MATX",0,(([ActualStaffTime]/[NoMatxTotal])*[MATXHours])))

Instead it comes up with errors on the fields ActualStaffTime, NoMatxTotal, MatxHours.

What am I missing?

 

[traycee]

I'm going to answer my own question as to summing this control, since I figured it out, it may help someone else.

First, I copied the text box control and pasted it in the same footer area as the original control. I then went to the controls properties and made the running sum on the new text box control equal to 'over group'. Once I verified it was calculating correctly I went back into properties and made visible equal to 'no'. Next, I added a text box control to the report's footer section to display the total by referencing the RunningSum property and it works great! Hope this helps someone having the same problem.

 

[aspnetuser]

traycee, I am attempting the same thing. However I need to display the final running sum in the group footer. When I try to do this, it just is blank.

I see the running sum in the details section of my report calcing correctly. Any ideas???

 

[idcowboy]

Tried it and still not working HELP