Sums in Report Groups (1 Viewer)

mic

New member
Local time
Today, 08:47
Joined
Mar 9, 2011
Messages
2
I'm sure this has been addressed, but I cannot find the answer that I am seeking. I am trying to have sum totals for categories within a group. Ex:

Location1 Mgmt Active 12
Quit 4
Term 2
Hourly Active 60
Quit 6
Term 7

Location2 Mgmt....


I would like to be able to show a summary on the footer for Location that would show:

Total Active 72
Total Quit 10
Total Term 9

Running sum does not work for this. I can create groupings for each status (Active, Quit, etc.) but I cannot sum up the totals on the location footer.

Thanks in advance for your help.
 

vbaInet

AWF VIP
Local time
Today, 16:47
Joined
Jan 22, 2010
Messages
26,374
Take Active for example:
Code:
=Sum(IIF([Location] = '[COLOR=Red]Active[/COLOR]', [Mgmt], Null))
Note: I'm guessing Location1 was a typo so I called it Location in the code.
 

mic

New member
Local time
Today, 08:47
Joined
Mar 9, 2011
Messages
2
Thanks for the help. That was simple, I feel dense. I have been out of the programming world for a pretty long time and it is a little slow coming back.
 

vbaInet

AWF VIP
Local time
Today, 16:47
Joined
Jan 22, 2010
Messages
26,374
You're welcome.

Soon you will get back into the swing of things.
 

Users who are viewing this thread

Top Bottom