Discussions

Expand all | Collapse all

Total Average From Summary Reports

  • 1.  Total Average From Summary Reports

    Posted 04-18-2017 18:19
    Hello,

    I am trying to use a summary report to list the total sales each of our sales reps wrote over the last 7 weeks, but instead of totaling their 8 week sales, I would like to average them.

    Right now, the main body of the report works perfectly - the total for each rep by week comes up.  The only thing I need to fix is the average for each rep over the previous 8 weeks.

    I appreciate any help.  Hoping for a simple solution or checkbox I'm missing.  Thanks!


  • 2.  RE: Total Average From Summary Reports

    Posted 04-18-2017 18:22
    you should be able to define the column in your summary report as average instead of total.


  • 3.  RE: Total Average From Summary Reports

    Posted 04-18-2017 18:24
    On a Summary report when you choose which field(s) are to be be Summarized you can choose to Summarize by "Averages" instead of by "Totals"  if you like you can summarize the same field twice on the report, once each way.


  • 4.  RE: Total Average From Summary Reports

    Posted 04-18-2017 18:24


    Yes, I did see that.  Unfortunately, I would like the weekly listings to be total, and only the final row to be averaged.


  • 5.  RE: Total Average From Summary Reports

    Posted 04-18-2017 18:26
    Can't do that natively.


  • 6.  RE: Total Average From Summary Reports

    Posted 04-18-2017 18:28
    Darn, thank you both for your input.