7 Replies Latest reply on Jul 25, 2018 1:57 AM by Mahfooj Khan

    Up and Down Arrows -

    Lisa Holdin

      I added a formula for my up and down arrows but it is not recognizing the 0 Data - Example Feb 18th should be a down arrow - Is there something wrong with my formulas. 

       

      IF avg([SLA Attainment]) = 0 THEN 'No change'

      ELSEIF avg([SLA Attainment]) - LOOKUP(avg([SLA Attainment]), 1) <= 0 THEN "Down"

      ELSEIF avg([SLA Attainment]) - LOOKUP(avg([SLA Attainment]), 1) >= 0 THEN "Up"

      ELSE "Same"

      END