Average for group totals

[danboy1]

Hello,

I'm trying to do an average for the number of calls for each day. I have created the group which calculates the total number of tickets by day as shown below:

Do I need a variable, thought this would be easy enough for seems tricky...

Thanks

DateRecieved CountOfTickets

01/11/2012 24
02/11/2012 30
05/11/2012 25
06/11/2012 36
07/11/2012 41
08/11/2012 40
09/11/2012 25
12/11/2012 36
13/11/2012 29
14/11/2012 345
15/11/2012 195
16/11/2012 29
18/11/2012 1
19/11/2012 50
20/11/2012 38
21/11/2012 47
22/11/2012 31
23/11/2012 32
25/11/2012 1
Total 1,053
Average ???

[jggtz]

Right click over a detail field (could be CountOfTickets)
A context menu is displayed
Select Insert / Sumary
An Insert summary window is displayed
Select "Count" in Calculate this summary combo
Select "Group footer" in Summary location
Click on Ok button
-Now you have a count of rows, and you could use it to calculate the average inserting a formula field

[danboy1]

Hi

[danboy1]

Hi

I already did that it was the actual formula I need to get the average from the group totals: got around it with this:

Whileprintingrecords;
numbervar x;
x:=x+1 // place this on your group

formula to get average :

Whileprintingrecords; // Place this formula where you want to show average.
numbervar x;
{YourTotalTickets) / x;


Thanks