how to show average on a report

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

At the bottom of a report instead of it showing a total how can I have it show the average of all the numbers in a column?

Photo of Marci

Marci

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
no problem,

Change the field properties of the field to checkbox the Show Averages box.
Photo of Francesco Spiga

Francesco Spiga

  • 264 Points 250 badge 2x thumb
what if I need to show the average of a calculated column? is that possible?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,912 Points 50k badge 2x thumb
I think that you would need to create a real field to get more control over the format and totals / averages
Photo of Francesco Spiga

Francesco Spiga

  • 264 Points 250 badge 2x thumb
I guess the option is not available for a calculated field. Thanks for your reply. A new field would definitely allow me to pick either total, avg or both.