3 Replies Latest reply on Mar 9, 2018 7:03 AM by Jim Dehner

    Conditional formatting of shapes with 2 conditions for KPIs

    Liza Scanlon

      Hi

      I would appreciate some help on this calculated field to show the conditional formatting of some shapes.  It is only half working and I know it will be something simple!

       

      I have two conditions - a required direction of travel (increase or decrease) for each indicator then depending on whether the one year change is an increase or decrease will depend on whether the colour should be red or green.

       

      I have created another calculated field to give me the shape.  Only half of the formula is being recognised the bottom section is not getting picked up - what have I done wrong?!!Screen shot and formula below

       

       

      case ATTR([Required Direction of Travel of Indicator]) when 'Increase' then

      if [1 yr DofT] = "Up" then "G"

      elseif [1 yr DofT] ="Down" then "R"

       

      else

       

      case ATTR([Required Direction of Travel of Indicator]) when 'Decrease' then

      if [1 yr DofT] = "Up" then "Red"

      elseif [1 yr DofT] ="Down" then "Green"

      else "B"

      END end END END

       

      Any help would be greatly appreciated

      Many Thanks

      Liza