CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2012
    Posts
    3

    Question 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. #2
    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
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

  3. #3
    Join Date
    Nov 2012
    Posts
    3

    Re: Average for group totals

    Hi

  4. #4
    Join Date
    Nov 2012
    Posts
    3

    Re: Average for group totals

    Quote Originally Posted by danboy1 View Post
    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
  •  





Click Here to Expand Forum to Full Width

Featured