0 Replies Latest reply: Aug 1, 2014 9:58 AM by Pandiarajan Radhakrishnan RSS

    Prevous value based different Column

    Pandiarajan Radhakrishnan


      Dear all,

       

           i want to reduce stock value based on previous location and Item

       

      Find Below My Input Data :

       

      LocationItemLineIDDaysReqAvailable
      XXXABCLine146132
      XXXABCLine240132
      YYYABCLine35516
      YYYABCLine44316
      YYYABCLine54016
      YYYABCLine63416
      YYYABCLine72316
      YYYABCLine8516
      YYYABCLine9316

       

      I want this Output

       

      LocationItemLineIDDaysReqAvailableoutput
      XXXABCLine14613231
      XXXABCLine24013230
      YYYABCLine355165
      YYYABCLine443164
      YYYABCLine540163
      YYYABCLine634162
      YYYABCLine723161
      YYYABCLine85160
      YYYABCLine9316-1