Flag every time a value changes in a column

[bmittal11]

INPUT:

Desired OUTPUT:

I am already using a multi- row formula to flag this. But I am having problems with the result  I am getting, Instead of the "Desired OUTPUT" mentioned above  I am getting this. As you can see the formula works for some vales in the "DecodedValue" column. I don't know why it doesn't work for each change in value.

Multi-row formula being used: 

[MarioAA · Accepted solution]

Hello!

I think the formula should be just if [Row-1:DecodedValue] = [DecodedValue] THEN 1 ELSE 0 ENDIF

Try this

Mario

[CathyS_Slalom · Accepted solution]

Hi @bmittal11, you can use the formula below to get the desired output.

IF [DecodedValue] = [Row-1:DecodedValue] OR IsEmpty([Row-1:DecodedValue])
THEN 1
ELSE 0
ENDIF

[Emmanuel_G]

Hi @MarioAA ,

Find attached one way to do it easily.

Let me know if there is any concern.

Cheers !