So as part of our end of analysis I was looking at services across branches, with an eye towards revenue per hour to see who was at the most efficient, and seeing what the other branches could learn from them as we get ready to renew. Something wasn’t quite adding up with what I was seeing. The Revenue/Hour (Actual) is not available as a “custom” or weighted average in the total row. I think what it is doing is instead of giving the average of all revenue divided by all hours, it is figuring the Rev/Hr for each ticket, adding those all together, and then dividing by number of tickets. I went into custom formulas, and was very easily able to create my own that does provide the custom format. The variance isn’t crazy on some services, but it was typically in the $50-$90 range. Enough to really change how we think of these services.

I don’t know if anybody else uses this data to help inform decision making processes, but if you do, I would HIGHLY recommend going in and creating your own formula so it doesn’t inflate that data.