-
November 26th, 2012, 11:56 AM
#1
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, 04:29 PM
#2
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
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
-
November 27th, 2012, 05:06 AM
#3
Re: Average for group totals
-
November 27th, 2012, 05:08 AM
#4
Re: Average for group totals
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|