Total Average From Summary Reports

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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!
Photo of Caitlyn

Caitlyn

  • 506 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
you should be able to define the column in your summary report as average instead of total.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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.
Photo of Caitlyn

Caitlyn

  • 506 Points 500 badge 2x thumb


Yes, I did see that.  Unfortunately, I would like the weekly listings to be total, and only the final row to be averaged.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Can't do that natively.
Photo of Caitlyn

Caitlyn

  • 506 Points 500 badge 2x thumb
Darn, thank you both for your input.