Custom Reports need more options for numeric values other than TOTAL (like AVERAGE, MIN, MAX, COUNT) without grouping or removing fields
For numeric fields in a custom report there is currently a "Total Column" checkbox option to total the data from all rows in that column. The total will display in a new row at the bottom of the column.
We'd like the same thing but with the option for Average, Min, Max, Count, etc. Those are only possible now by grouping and removing all other fields. We end up with the calculated value but can't see any of the individual records or details. We can get what we need in Excel by exporting and adding a formula but would like our staff to be able to reference live CSuite reports with this information.
22
votes
Bryant Phillips
shared this idea