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


      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"


      "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



      I have null value

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