4 Replies Latest reply: Jun 8, 2016 1:28 PM by gidon david RSS

    Adjust cells

    gidon david

      Hi guys

      I have a issue that needs help

      I get price list for products for each month

       

      in some cases , if the price is 0 I need to get the last know price

      as you can see PN 200 for month 062016 is  0 , in this case I need to load it as 150 as it is the price for 052016

      thanks for your help

      gidon

       

          

      PNYearMonthPRICE
      10001201610
      10002201620
      10003201630
      10004201640
      10005201650
      10006201660
      200012016110
      200022016120
      200032016130
      200042016140
      200052016150
      2000620160
      300012016210
      300022016220
      300032016230
      300042016240
      300052016250
      3000620160
      400012016310
      400022016320
      400032016330
      400042016340
      400052016350
      400062016360