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



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


      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.