Conditional Averages.

[Rhaegar]

In my report I group by day and in each day the agents working a phone system are listed with information like logged in time, calls answered etc. At the end of each group I work out the average for that day (i.e. average logged in time). However, I only want to find the average of agents logged in for a certain amount of time (say greater than 1 hour) however I still want to actually list those agents in the report. As a result I cannot use the traditional average formula because it would include agents that have logged in for less than an hour and I'm not allowed to modify the sql statement to remove such agents. I need to write a formula but I'm not sure how to go about it. I need a way to say "find the average of all agents in a group that have a logged in time greater than 1 hour".

Any help appreciated.

 

[mbarron]

You can use a running total to accomplish this.

For your Evaluate, use a formuala.({time}>1hr). Reset on Change of Group. Mike

 

[Rhaegar]

Thanks