Preguntón Posted April 21, 2005 Share Posted April 21, 2005 Hi! It is very urgent for me to get the formula for the averages in the following report: Month: January 2005 Name/Attended Calls/Converted Calls/Other Area John/150/100/45 Peter/180/98/28 Mary/-/-/60 Ben/85/33/12 Averages/138.33/77/36.25 Every figure for each person is the SUMMARY of individual records. Note that the average is based on number of non-blank SUMMARY groups. I will appreciate any help on this. Tks a ton Link to comment Share on other sites More sharing options...
aaa Posted April 22, 2005 Share Posted April 22, 2005 Create Summary field for all Attended_Calls, then calculate how many different names you have. Your average by Attended_Cals will be deviding this two values. If i dont undestand traly, it will be good if you attach your file. Link to comment Share on other sites More sharing options...
Preguntón Posted April 22, 2005 Author Share Posted April 22, 2005 Ok, the thing is how can I calculate how many different names I have, and at the same time, how can I get the average calculated only for those who are not empty in each column? Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.