4 Replies Latest reply on Nov 22, 2018 1:09 AM by Mahfooj Khan

    Forward fill values

    Vikram Philar

      Hello,

       

      In the data source area, suppose I have a column A that has a value of zero in most of the rows except a few. I want to create a new column B based on the values off A and forward-fill the same value until a non-zero value is encountered in A. Repeat the process until the entire column B is filled. It's OK if Column A doesn't have any values to begin with. In that case, Column B would obviously have empty values until it encounters a non-zero value in Column A and that's fine. Here's an example:

        

      Column AColumn B
      22
      02
      02
      44
      77
      07
      07
      07

       

      I have tried this:

       

      IIF (ISNULL([Column A]), PREVIOUS_VALUE([Column A]), [Column B]) but it doesn't give me the desired result.

       

      Any suggestions please?