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! Go to Solution.
Try this:
AND(OR([EMAILCORREDOR]=USEREMAIL(), USEREMAIL()= "email@gmail.com"), [FINALIZADO]<>"OK")
The formula that I´m trying is the next:
OR( [EMAILCORREDOR]=USEREMAIL(), USEREMAIL()= "email@gmail.com", [FINALIZADOS]<>"OK")
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
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |