FINDING AVERAGE OF CALLS PER DAY PER MONTH

[ann1]

Hi Everyone
I am being asked to provide a report that gives the average number of calls dealt with per day during a month.

The report needs to run for the year from July 2002 to end August 2003. I have used datediff but this is giving me the number of days including weekends but this particular contract runs Monday to Friday (exc Bank Holidays).

What formula can I use to calculate:
- the number of working days per month
- the average number of calls per month (using working days)

It sounds simple ... so I may just be being dim!! Thanks for your help!

 

[basil3legs]

You can get rid of the weekends by doing something like:

numberofdays = Datediff("d", d1, d2) - Datediff("ww", d1, d2, crSaturday) - Datediff("ww", d1, d2, crSunday)

where d1 and d2 are the start and end of the month. This is straight from the Crystal help files, however they don't mention how to take out holidays, which vary from country to country anyway. Yuo may need to add a list of these in manually and check how many are in your date range (Yuk!!)

 

[Madawc]

You need to set up a dataset specifying which days in a month are working days. Or you could hard-code it, but a dataset is better, and it could also include the total number of days in each month

Group by month (you can extract year and month number using DatePart). Do group totals and also an average, running totals give you a lot of options for Crystal, including a choice of mean, median and mode.

Madawc Williams
East Anglia, Great Britain