3 Replies Latest reply on Nov 24, 2018 12:24 PM by alex delfabro

    Compare time (hh:mm) to time (hh:mm) with three conditions

    CHRISTINE RECORD

      Hello everyone

      I have to compare arrival real time to target time:

      if real time <= target time then " in the target"

      if not

      I have to compare current month real time to previous month reel time:

      if current month real time <=  previous month reel time then "out of the target but better then previous month"

      else

      "out of the target"

       

      I have to get three result

      - in the target

      - out of the target but better then previous month

      - out of the target

       

      note:

      I have null value

      If I can get the result with barre chart it's better

       

      Thanks