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)
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.
User | Count |
---|---|
37 | |
31 | |
28 | |
22 | |
18 |