6 Replies Latest reply on Dec 28, 2015 12:53 PM by Baris Sagiroglu

    Assign value to a cell based on a different cell in the same column

    Baris Sagiroglu

      Hi,

       

      I'm trying to create a table that would show the Quantity by Level by Date. In the attached workbook, the "As is" sheet shows the data without any manipulation. The "Using multiples" sheet tries to update the Level0 and Level1 values based on the value from Level2. As you can see, using "exclude"/"include" I managed to do this but it fails when Level0 or Level1 is null when you filter the data. For example, in below table Level0 and Level1 are calculated by multiplying Level2 value by 3 and 1.5 respectively. For April because there was no value for Level1, the calculation of Level2Value*1.5 doesn't happen.

       

             

      Date
      LevelDecemberJanuaryFebruaryMarchAprilMay
      Level063.09.03.039.06.0
      Level131.54.51.519.5
      Level221.03.01.013.02.0
      Level3186.014.083.065.0
      Level490.0 160.0 3.0
      Level5383.0