Second condition in a row filter in a slice

Hi you all !!!

I have a row filter condition in a slice, where I filter the data upon a user email:

OR( [EMAILCORREDOR]=USEREMAIL(), USEREMAIL()= "email@gmail.com")

My question is if it´s possible to add a second condition, It would be that filter the records with the condition of a field empty. It means that filter for the useremail and the records of a field that must be empty.

I don´t know how to add as a second condition.

Thanks in advance,

Javier

Solved Solved
0 5 140
1 ACCEPTED SOLUTION

Try this:

AND(OR([EMAILCORREDOR]=USEREMAIL(), USEREMAIL()= "email@gmail.com"), [FINALIZADO]<>"OK")

View solution in original post

5 REPLIES 5

The formula that I´m trying is the next:

OR( [EMAILCORREDOR]=USEREMAIL(), USEREMAIL()= "email@gmail.com", [FINALIZADOS]<>"OK")

Steve
Platinum 5
Platinum 5

Hi Steve. Thank you for your help.

The formula is  AND( [EMAILCORREDOR]=USEREMAIL(), USEREMAIL()= "email@gmail.com", [FINALIZADO]<>"OK"), but I get no any records

Try this:

AND(OR([EMAILCORREDOR]=USEREMAIL(), USEREMAIL()= "email@gmail.com"), [FINALIZADO]<>"OK")

It works !!!!

Thank you very much, Steve.

Regards, 

Javier