1 Reply Latest reply: Mar 16, 2011 6:10 AM by Corrado Lorefice RSS

    STOCK DAYS OF COVERAGE, PIVOT PROBLEMS

      HI there,

      does anybody know how to solve the problem below?

      Desired Result 1: is the consumption of actual stock of code A. At a given time 24/11 you start with a stock of 1000 and I would like to know how the stock will evolve by fulfilling orders.

      Desired Result 2: I would like to know how many days of coverage I have before getting out of stock.

       

       

      id_code_dwlogdt_date_order22/11/201023/11/201024/11/201025/11/201026/11/201029/11/201030/11/201001/12/2010
      E1340607080 0807STK Beginning Period
      840
      840840840840840840840
      XXXXDESIRED STOCK Beginning period EVOLUTION84083756732757-123-273-423
      E1340607080 0807ORDERS3270240270180150150270
      XXXXDESIRED STOCK End period EVOLUTION83756732757-123-273-423-693
      XXXXDESIRED FULL DAYS OF COVERAGE43210000
      IDENTIFYING STOCK OUT11110000
      IDENTIFYING STOCK OUT DATEFALSOFALSOFALSOFALSO26/11/201029/11/201030/11/201001/12/2010