Multi Row formula issue

[Joker_Hazard]

Hey!

I am trying to create a simple formula that checks if the previous date is different. I was able to do that, however, once it detects a "NOT" then ALL subsequent rows should also be NOT as well, so I can filter this information later on. How can I do that using multirow? Is there any advanced logic for that?

Also, we should skip the first row, so THAT it will only contain one "NOT" in the whole dataset.

Thanks!

[DataNath · Accepted solution]

@Joker_Hazard is this what you're after?

I think the issue with your Multi-Row to start with was not using this configuration for rows that don't exist:

[Joker_Hazard]

@DataNath Always saving me! Thank you very much once again mate! If you ever come to Brazil, São Paulo, I can pay you a beer! 

[binuacs]

@Joker_Hazard Another way of doing this