The Open Case and Closed Cases Report can be used to track the average costs incurred for open and closed cases.
Tracking the Average Cost for all Open Cases:
The Open Cases report includes a Costs column to track the total costs for each open case. Apply any applicable filters, remove any unnecessary columns, and select the Export icon to export the report into Excel. Within Excel, you can use Excel's formulas feature to calculate the average of the sum of costs divided by the total number of open cases.
Tracking the Average Cost for all Closed Cases:
The Closed Cases report includes a Costs column to track the total costs for each closed case. Apply any applicable filters, remove any unnecessary columns, and select the Export icon to export the report into Excel. Within Excel, you can use Excel's formulas feature to calculate the average of the sum of costs divided by the total number of closed cases.