Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    228

    Unanswered: Running Average on a Report

    I have a report that has a grouping level for each person:

    Person A
    date - #1 - #2 - #3 - AVG - Overall AVG
    9/13/2004 - 200 - 200 - 200 - 200 - XXX
    9/20/2004 - 100 - 100 - 100 - 100 - 150
    9/27/2004 - etc

    Person B
    date - #1 - #2 - #3 - AVG - Overall AVG
    9/13/2004 - 225 - 225 - 225 - 225 - XXX
    9/20/2004 - 125 - 125 - 125 - 125 - 175
    9/27/2004 - etc

    How do I get a text box for each person to keep a running average of that persons score?

  2. #2
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    add a textbox in your report. set control source to AVG field and set Runningsum option of the textbox yes. thats should do it.
    ghozy.

  3. #3
    Join Date
    Sep 2003
    Posts
    228
    I did what your suggested in regards to the running sum property but, that only addd up the averages...

    I added a counter that increments for each line and resets to zero for each new person. I divided the summed average by this count and used that value for my running average.

  4. #4
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    I didn't notice you want running average. sorry my bad. but you seem to fixed your problem anyway.
    ghozy.

Posting Permissions

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