List Report - Average the data

toneyvecchio1
Tera Expert

My manager was attempting to create a list report and when he was using it, the list had a bottom piece where it averaged out the values. However we have not been able to reproduce this ever since. I having included a screenshot and have attempted to recreate but have been unsuccessful. Does anyone know how to add this "footer" or average piece?

ListReportAvgs.jpg

1 ACCEPTED SOLUTION

Brad Tilton
ServiceNow Employee
ServiceNow Employee

You can actually set this in the list view (not specific to a report) of a table. Go to the list header, right click and choose Personalize > List Calculations and you'll have the option to do averaging, totaling, etc.



Totaling in Lists - ServiceNow Wiki


View solution in original post

7 REPLIES 7

Brad Tilton
ServiceNow Employee
ServiceNow Employee

You can actually set this in the list view (not specific to a report) of a table. Go to the list header, right click and choose Personalize > List Calculations and you'll have the option to do averaging, totaling, etc.



Totaling in Lists - ServiceNow Wiki


Thank you so much!


peterwestergaar
Kilo Expert

I think you mean that when you were designing the report, you can right-click on a column header of interest in the list result, and choose: "Personalize:   List Calculations" and choose to display an Average for that column.



Is that what you were looking for?          


Brad totally got it first.