Hi,
I have seen a few post along a similar line to this but as yet haven't found oen to fix my problem.
I have a report which looks at the time difference between the time a call is received and the time an action is taken. Each call is allocated to a worker. We want to know the time difference between the call time a repsonse time, and then the average time each worker take to respond.
I have suprssed some records as there are duplicates for the job ID and the worker (this is correct we expect duplicates as multiple responses at later times/dates are logged to the same call number) and we are just interested in the first call to response times for this report. For info there are occasions when no response time is logged and these are supprssed too.
I have tried using a running total average for each workers ID but the calculation is incorrect, the formula I have used in the evalute section of running total is
NOT (isnull ({MB_MOBILISATIONS.MB_MOBILE})
or{MB_MOBILISATIONS.MB_IN_REF}=previous({MB_MOBILISATIONS.MB_IN_REF})and {MB_MOBILISATIONS.MB_CALL_SIGN}=previous({MB_MOBILISATIONS.MB_CALL_SIGN}))
Not sure where I am going wrong! any help gatefully received and any questions please let me know
Thanks