0 Replies Latest reply: Jul 26, 2018 1:35 PM by Elizabeth Viso RSS

    Comparing Month to Month Trend with Indicators

    Elizabeth Viso

      Hello,

       

      I have a pivot table that has two columns, one shows the average compliance score then the next column shows the trend with arrow indicators.

       

      For the compliance average I use this expression:

      =Avg([UMHC SYSTEM])

       

      For the arrow indicators I use this expression:

      If(Avg([UMHC SYSTEM]) >0.945,Black(),

      If(Avg([UMHC SYSTEM])>0.84,Black(),

      If(Avg([UMHC SYSTEM])>0,lightRed(),

      Black())))


      What I want to do is have the trend indicator arrow go up if the percentage from month to month is going up, and an arrow going down if the percentages have gone down from month to month. And if there is no change just a dash.


      Can anyone help me with this?


      Thank you!


      Capture_7_25_18.PNG