Hi there, i am having some problems with a Crystal Report. I have created a report showing the duration of calls within a HEAT System. The calls are grouped into the below areas:
Under 4 Hours
Under 8 Hours
Under 2 Days
Under 3 Days
What is required is the following:
Duration of Call(Group) Number of Calls Cumalative %
Under 4 Hours 300 30% Calc(300/1000)
Under 8 Hours 300 60% Calc(600/1000)
Under 2 Days 100 70% Calc(700/1000)
Under 3 Days 300 100% Calc(1000/1000)
Total Calls 1000
I don't know how to achieve this in a Grouped report in Crystal - what would i use in a formula to do this?
Any help would be greatly received.
Regards
TimI think you want the PercentOfCount function, e.g.
PercentOfSum (call, inner, outer)
So if your report were grouped on, say,
1) Call centre
2) Duration
You would want: PercentOfSum(call, duration, centre)
Anyway, read the help on the PercentOf... functions.|||Sorry, I kept writing PercentOfSum instead of PercentOfCount
No comments:
Post a Comment