Good morning people, everything fine ?
I would like to make a filter as follows.
If column $Operation Type$ = SVP and $Status$ ≠ (different) “BIG Seller” => TRUE
Good morning people, everything fine ?
I would like to make a filter as follows.
If column $Operation Type$ = SVP and $Status$ ≠ (different) “BIG Seller” => TRUE
This should do:
$column3$ = "SVP" AND NOT $column2$ ="BIG Seller" => TRUE
You will need to edit the column names accordingly. It is also not clear if you want to include or exclude as per those criteria so you may have to change the radio button from Include TRUE matches to Exclude TRUE matches if you want to “invert” this.
For the future: Including easily accesible data with input data and an example of desired output is always greatly appreciated as it makes it easier for people to help you.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.