4 Replies Latest reply on Jul 9, 2018 7:38 AM by James Ham

    Trend arrows and colours

    James Ham

      Hi all,

       

      I am trying to create a dashboard that uses some business logic.

       

      I have 4 different reporting periods with each period aiming for a target of 20.

       

      I would like to achieve the following:

       

      - Use a Up/ Down trend arrow depending on the performance of the reporting period. EG if 20 for June and 21 for July, the trend would be up.

      - Use a colour code against the target. EG if for June 20 then Green and 21 for July Red.

       

      I have tried a number of formulas however none have worked.

       

      Any help would be appreciated.

       

      Thanks.