how to show average on a report
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?
Forum Discussion
- no problem,
Change the field properties of the field to checkbox the Show Averages box. - what if I need to show the average of a calculated column? is that possible?
- I think that you would need to create a real field to get more control over the format and totals / averages
- 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.
