Forum Discussion

dogt1225's avatar
dogt1225
Helper III
5 years ago
Solved

Rolling Average Calc

I need some assistance with my Rolling Average calculation. Looking to get the Rolling average of my ADR (Average Days to Resolve) measure.     ADR = IF( [Cumulative Sum of Days to Resol...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

You are comparing the result of a division with blank?  Please use DIVIDE() instead, it has error handling built in.

dogt1225's avatar
dogt1225
Helper III
5 years ago

Hi lbendlin, Thanks I will update that for my Cumulative calculation. But do you have any suggestions for getting the Rolling Average?