Hi Qaisar, thanks for getting in touch! from what I have experimented with this on my side this is not working accurately, what are you trying to do? just in case you can try with this example:
a98f956a-1fab-4ac1-9758-b3a93522a6aa.png(74 kB)
Formula to Make Decisions Based on Previous Rows' Values | Clay