0 Replies Latest reply: Oct 3, 2012 5:56 AM by joris_navius RSS

    Help on cumulative calculation in record looping

      Dear pals,

       

      I need your help to give me some idea on how to solve the below issue.

       

      Current data that I have

       

      Capture.JPG

      As you can see the above, my raw data will look like

      Capture2.JPG

      What I am trying to achieve is to determine the status of each Schedule Delivery Date, because the total quantity is spread out to several schedule date with schedule quantity.

      The total delivery itself also refered to the item no, thus the logic is to sort the schedule delivery date, get the Total Quantity of the item - Schedule Delivery Quantity per Schedule Date (cumulative calculation).

       

      Please help on how I can achieve this.

       

      Thank you.