# Average for group totals

Printable View

• November 26th, 2012, 10:56 AM
danboy1
Average for group totals
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 ???
• November 26th, 2012, 03:29 PM
jggtz
Re: Average for group totals
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
• November 27th, 2012, 04:06 AM
danboy1
Re: Average for group totals
Hi
• November 27th, 2012, 04:08 AM
danboy1
Re: Average for group totals
Quote:

Originally Posted by 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