row filter still showing when fause

I have a row filter in a slice that is woring and returing a Y or a Fause as needed. but its still showing but with a warning see image. can someone please help .

IF(LOOKUP( USEREMAIL(), "JOBDETAILS" , "User" , "job_Number" ) =[Job_Number] , TRUE, FAUSE)

steven_boyton_0-1644620827161.png

 

0 2 66
2 REPLIES 2

It should be FALSE not FAUSE.

Also since the expression 

LOOKUP( USEREMAIL(), "JOBDETAILS" , "User" , "job_Number" ) =[Job_Number] will evaluate to TRUE or FALSE , a further evaluation with IF(....) is not necessary. Simply 

LOOKUP( USEREMAIL(), "JOBDETAILS" , "User" , "job_Number" ) =[Job_Number]   will do.

Top Labels in this Space