Total Average Shown in Group

[shelby55]

Hi

I'm using Crystal 8.5 reporting from an SQL database.

I have a report with 3 groups: physician, registration date (weekly), and shift. There are 3 shifts: 0701 to 1500, 1501 to 2300, 2301 to 0700.

I am creating a report per physician (new page starts after each) and have a Total group (the metric for all physicians) area showing in the physician footer.

So for the Total average the formula would be:

whileprintingrecords;
shared numbervar d_avg;
d_avg:=weightedaverage({@LOS}/{Visits});

I'm able to create all metrics for totals but how would I do this if I want a departmental total per shift? Thanks.

 

[Madawc]

Easier to do using Running Totals rather than writing your own formulas. The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

You haven't explained how department fits into your data, e.g., can physicians be in multiple departments? Where are you grouping on department? Would be a higher order group before the group on physician, or? You should also show the content of {@LOS} and it wouldn't hurt to explain what you mean by 'LOS'.

-LB

 

[shelby55]

Hi LB

Thanks for everyone's help but I just went ahead and used a subreport at the shift level and it's working great.

Thanks again.