Sum of Group average 4

[talibm]

Hi all, I am trying unsuccesssfully to create a formula to sum the average of a field. I have created a worker productivity cross tab report which is based on services provided to our clients. One of the services we provide is group counseling. In a group there may be 10 clients and the total time for the service is 180 minutes or 3 hrs. The details section shows 180 minutes for each client, but the worker productivity is 3 hours. The report is grouped by worker, service code, start date, and total time. i need to sum the average for total which has been converted to hours.I created this formula for the group service:

If {SERVICECODES.SERVICECODE} = "Group" then
Average ({ACTIVITIES.TOTALTIME},{ACTIVITIES.TOTALTIME})/60.
It returns this:
Date start end no.Clients totaltime prod
3-1-08 9am 11am 10 1200 2hrs
3-2-08 1pm 4pm 5 900 3hrs

So for each group service i get the average or the actual productivity for the worker, but I can't get a sum of the average. Ive tried running totals but I can't get it to reset. How do I sum the results for productivity. I am trying to create a manual cross tab report but I can't figure out how to sum the average


Thanks

 

[rafeman]

Hi, I have the following table

PRIMARY DATE GROUP
1 10/08/08 Residential
2 12/08/08 Self Build
3 10/08/08 Self Build
4 11/08/08 Domestic
5 09/08/08 Residential

The user wants a report as following;

Parameter (Date)

Qty Tasks Qty Tasks Qty Tasks Qty Tasks Qty Tasks
Day Yesterday Week Month YTD

So by entering 10/03/08 we get

2 1 5 5 5

I have no idea of a method on how to achieve this other than running totals. Can anyone point me in the right direction.

This will also be grouped by Residnetial etc.

Thanks