Discussions

Expand all | Collapse all

how to show average on a report

  • 1.  how to show average on a report

    Posted 12-03-2015 19:33

    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?



  • 2.  RE: how to show average on a report

    Posted 12-03-2015 20:00
    no problem,

    Change the field properties of the field to checkbox the Show Averages box.


  • 3.  RE: how to show average on a report

    Posted 02-20-2018 15:37
    what if I need to show the average of a calculated column? is that possible?


  • 4.  RE: how to show average on a report

    Posted 02-21-2018 14:31
    I think that you would need to create a real field to get more control over the format and totals / averages


  • 5.  RE: how to show average on a report

    Posted 02-21-2018 15:02
    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.