Multi Row formula issue

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!

Workflow

Accepted answers

@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:

Ok and not ok flag.yxmd

All comments

@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:

Ok and not ok flag.yxmd

@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!

@Joker_Hazard Another way of doing this

Multi_Row_01_07.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15881

MarqueeCrew 13708

apathetichell 13703