4 Replies Latest reply: Sep 1, 2017 3:35 AM by beck bakytbek RSS

    take over the value if i have last value

    beck bakytbek

      Hi Folks,

       

      i got question, in my issue i have the following values:

       

      Projekt, ID, Name, Datum, Value

      PR_1, 1, Test1, 15.06.2017, 20 €

      PR_2, 2, Test2, 30.06.2017, 40 €

       

      where Project= PR_2 and ID = 2 are my last Value,

       

      my question is, how can take over on the base of last ID, all value for next ID and with Datum: 30.07.2016,

      the problem with next Month,i already solved,

       

      My expected outpu is:

       

      Projekt, ID, Name, Datum, Value

      PR_1, 1, Test1, 15.06.2017, 20 €

      PR_2, 2, Test2, 30.06.2017, 40 €

      PR_2, 2, Test2, 30.07.2017, 0 €


      does anybody have any ideas?


      Thanks a lot

      Beck