1 Reply Latest reply: Aug 18, 2016 10:24 AM by Adam Davies RSS

    Help with table

    juan prado

      Hey guys i have this problem:

       

      I have a table like this:

       

      ClientPeriodMoney
      Client_1201601100
      Client_220160150
      Client_320160170
      Client_1201602110
      Client_220160260
      Client_1201603120
      Client_320160370

       

      And i need to generate a table where for all periods take the money and if i dont have money for that period, repeat the last money, something like this:

       

      ClientPeriodMoney
      Client_1201601100
      Client_220160150
      Client_320160170
      Client_1201602110
      Client_220160260
      Client_320160270
      Client_1201603120
      Client_220160360
      Client_320160370

       

       

      Thanks you in advanced!