Skip to Content
0
Former Member
Mar 06, 2009 at 07:25 PM

Running totals by group - need multiples?

65 Views

I'm doing a report that's reporting certain observations about a patient and aggregating them into group footer formulas checking that the maximum date for each observation is greater than 1/1/1900. Now, I want to report the totals per Provider, per Facility, and a total at the end. The only way I see to do this is to create three separate running totals on the same formula (checking the date, instead of checking the formula that checks the date), and putting them in their respective groups. Am I missing something really blatantly obvious here, or is that about right? Thanks.