4 Replies Latest reply on Aug 13, 2016 2:18 PM by Sandris Jermacans

    IF function for Calculated field

    Sandris Jermacans

      Hi,

       

      I have tried all possible functions but I am getting all sorts of errors, can anybody help me to solve this task?

       

      I want to make a Calculated field that looks up previous value in [RowA]  and if it the same as a current [RowA]  value it assigns 0 to [RowB] if not assigns current  [RowA] cell value to [RowB]. This is expected result.

       

      [RowA]   [RowB]

      4               4

      5               5

      5               0

      5               0

      6               6

      7               7