2 Replies Latest reply on Jul 24, 2018 3:08 AM by meenu choudhary

    IF AND Condition using Fixed

    Rajhesh Kumar A S A

      Hi All,

       

          I have a below table from which I need to find which same TTs are re-assigned (i.e. having different orders no). Through this I could see the attempts over the same TT.

       

      I need Calculation formula field using Fixed, IF AND condition - if feasible.

       

      TTOrder noteamReason
      TT12034WO2345Dispatch teamunable to trace
      TT12034WO2346Delivery teamdispatch delivered
      TT14302WO2347Dispatch teamdispatch delivered
      TT65471WO2358Dispatch teamunable to trace
      TT65471WO3147Dispatch team2nd Attempt failed
      TT65471WO3217Delivery teamdispatch delivered

       

      Output should be

       

      TTOrder noteamReason
      TT12034WO2345Dispatch teamunable to trace
      TT12034WO2346Delivery teamdispatch delivered
      TT65471WO2358Dispatch teamunable to trace
      TT65471WO3147Dispatch team2nd Attempt failed
      TT65471WO3217Delivery teamdispatch delivered

       

      Dispatch team - 2 TTs , 5 Order nos

       

      Thanks in advance.