Running totals by group - need multiples?

[Former Member]

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.

[Former Member · Accepted solution]

Hi Garratte,

Yes, by creating running totals you can achieve this. Create running total as follows

Go in running totals

Select the field which want to total it. Make sum as summary type.

In Evaluate select Use a Formula and click on X-2 (FORMULA EDITOR)

>cdate(1900,01,01) and = 'Provider'

In Reset

Select On change of group and select the groiup name.

This will resolve the issue.

Thanks,

Sastry

[Former Member · Accepted solution]

Right, I understand that. What I'm asking is, is there a better way to do this than to create three different running totals?

Let me give a bit more background, to make sure I'm doing this the most efficient way.

cPatient  cObs  cDate
--------  ----  -----
Patient1, Obs1, Date1
Patient1, Obs2, Date2
Patient1, Obs3, Date3
Patient2, Obs1, Date4
Patient3, Obs1, Date5
Patient3, Obs3, Date6

I have a formula called ObsObs1, which says

If cObs = "Obs1" Then
    cDate;

Then, I have a formula called PatObs1, which says

If CheckDate(Date(Maximum({@ObsBMI}, {Command.PID})), {?EndDate}) Then
    "Y"
Else
    "N";

The running total field won't let me use PatObs1 in a formula, so it looks like

CheckDate(Date(Maximum({@ObsBMI}, {Command.PID})), {?EndDate});

and then I have it count distinct cPatientValues, resetting each RT on the correct group -- provider, clinic, never.