I am using Crystal Report 8.5 with Symposium and trying to make an average for the month.
I am running into problems because I need to make this average using a group that contains results from a formula.
This is what I need to make my total avarege from. I've a group showing 20 business days which finds its results with
Sum ({CallsAnsweredDelay},{Timestamp}, "daily") /
Sum ({CallsAnswered}, {Timestamp}, "daily")
That part works just fine, I see my results for each day and they are accurate. Now, what I need to do is find out how to add those to give me the sum of the results to divide by 20 and make an average for the 20 business days but I cannot figure out how to do so.
I've run into this problem before, I cannot figure out how to make the sum of a group when its results are based on a formula, could someone give me direction?
Thanks in advance,
Phil
I am running into problems because I need to make this average using a group that contains results from a formula.
This is what I need to make my total avarege from. I've a group showing 20 business days which finds its results with
Sum ({CallsAnsweredDelay},{Timestamp}, "daily") /
Sum ({CallsAnswered}, {Timestamp}, "daily")
That part works just fine, I see my results for each day and they are accurate. Now, what I need to do is find out how to add those to give me the sum of the results to divide by 20 and make an average for the 20 business days but I cannot figure out how to do so.
I've run into this problem before, I cannot figure out how to make the sum of a group when its results are based on a formula, could someone give me direction?
Thanks in advance,
Phil