Average for group totals
 CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

# Thread: Average for group totals

1. Junior Member
Join Date
Nov 2012
Posts
3

## 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 ???

2. Senior Member
Join Date
Jul 2005
Posts
1,083

## 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

3. Junior Member
Join Date
Nov 2012
Posts
3

## Re: Average for group totals

Hi

4. Junior Member
Join Date
Nov 2012
Posts
3

## 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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•

Click Here to Expand Forum to Full Width