Expense Comparison Percentage Change

I've create an expense comparison that is MoM and I want to add a color rule that if it is greater than the average of that row then it highlights. I've looked at the color rule and it seems like it isn't quite working for row level coloring. A snip of it I need it to highlight these numbers because there is a big change from what it has been in the previous months.

Answers

  • How isn't the color rule working properly? How are you calculating the Average - is that stored in a separate column?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**