3 Replies Latest reply: Feb 8, 2016 5:50 AM by Sunny Talwar RSS

    How to build the a sum with differnet start dates?

    Christoph Goertz

      Hello,

       

      i have my articles with the date of the last inventory. I want to determine the number of the products that I have bought since the last inventory up to a certain date .

       

      For example: For the Product Tee: From the inventory date 1.1.2016 up to 31.1.2016

      = 30 units

       

      (Date dd,mm,yyyyy)

       

      DateUnits
      31.12.201510
      07.01.201615
      01.02.201615
      05.02.201620
      10.02.201615

       

       

      How can I solve this in one table?

       

      Many thx

      best regards

      Christoph