0 Replies Latest reply: Oct 20, 2017 2:36 PM by Mark Graham RSS

    Peek Help with script

    Mark Graham

      Hello Everyone,


      I'm tring to create a logic with the below sample data:


      Req O/P: 'Can fill' column


      ITEMIncoming DateIncoming_Qty  RequiredCan fill
      110/19/201781    12681
      111/1/2017122   45



      I have 126 units required.

      i'm getting 81 on one date. So, i can fill only 81 units.

      Now, the rem. quantity is 45. This can be filled with the incoming qty on 11/1/2017.

      Please see attached application.


      Any help is highly appreciated.