3 Replies Latest reply on Sep 20, 2018 6:48 AM by Jim Dehner

    Replicate the last valid entries in a table

    tobias.vancura

      Hi

       

      I have the following table with headcounts recorded in various units over time:

       

      YearUnitHeadcount
      2016A1
      2017A2
      2018A
      2016B10
      2017B20
      2018B30

       

      For 2018 there is no entry for Unit A. The logic should be, that in this case the value of the prior years should be replicated.

       

      I guess I have to create a second field Headcount_2 with some calculations, that will go back in time until it finds an entry in the corresponding unit field with a non-zero / non-null value.

       

      Any ideas how to tackle this?