Hello,
I have a problem creating a calculated field. I would like to create a field that contains the weighted average of phone call duration. Currently every month has upto three phone call types; Incoming, Outgoing and Extension. I have set it up so that the data is grouped by month with a total for each month and call type. Each record also contains a average of duration.
The problem is that once they calls are summerized by month and call type; the AVG. function no longer returns an accurate value. I need a way to calculate a weighted average so that when I look at all calls in a month I can get an accurate average of Call Duration.
I have tried :
Code:
Avg Duration: ([SumOfCall Count]*[AvgOfDuration])/[SumOfCall Count]
This code returns a value that is equuivilant to the AVG function.
Anybody have Suggestions?