I have a report which generates course run rates for a particular date period which works fine. The report includes a run rate which is simply the total number of course days that ran (were not cancelled) divided by the total number of days in the report period. All well and good.
I need to add some sub-summaries so that the run rates are also calculated when the courses are sorted by course stream (streams are classifications of training like subject areas).
So a given report for a month would have up to 13 sub-summaries based on course stream each with its own run rates per course stream displayed.
However I can't work out how to get run rates to appear - if i try to divide the summary of the days that ran by the summary of the total days, in the sub-summary field, I just get the run rate for the whole group of records.
Course 1 stream 1 - duration 2 days - not cancelled
Course 2 stream 1 - duration 3 days - not cancelled
Course 3 stream 2 - duration 1 day - cancelled
Course 4 stream 2 - duration 2 days - not cancelled
Course 5 stream 2 - duration 1 day - not cancelled
Course 6 stream 3 - duration 4 days - not cancelled
Course 7 stream 3 - duration 2 days - cancelled
the sub-summary for stream 1 should show a run rate of 100% (5/5 days ran)
the sub-summary for stream 2 should show a run rate of 75% (3/4 days ran)
the sub-sumamry for stream 3 should show a run rate of 66% (4/6 days ran)
I can run off these reports by searching by one stream at a time but i want a report that sub0summaries run rates for multiple streams over a given period.
Any advice gratefully received.