Hi Team,
Hope you are well. We are trying to build a formula where
1) if the value column has same value like "101" for all the three rows. then it should create diff column with 1. if there is a change for example row 5 to row 7. then it should mark "0" where there is a change. In this case "Regular" is marked as 0.
2)Then if the value of the diff column is 0 then it should create a column old_value and pick the previous value of the "value" column and put it inside the old_value.
3) The value in yellow color should be 1.
Please let me know how to go about this.
Formula
if [Value]!=[Row-1:Value] and [Row-1:Diff?]!=0
then 0
elseif [Value]!=[Row-1:Value] and [Row-1:ctr_key]!= NULL()
then 0
else 1
endif
the output should like below
