SLICE not filtering

Hey all,

So I'm a bit stumped on where I've gone wrong.

Please note the below code for a slice row level filter:
IN([_THISROW].[EMPLOYMENT LEVEL],SPLIT(LOOKUP(USEREMAIL(),ENUM LISTS,EMAIL,VIEW SLYC)," , "))

I'm also uploading what the tables and date currently looks like.

Essentially, the filter should look up the useremail in the enum lists table and return a cell filled with applicable employment levels comma seperated lists.
This should be compared to a column in the views table as to whether that particular view is filtered or not.

I've based this off another app which I created working fine, yet I can't figure out for the life of me where I'm going wrong.

Any assistance would be greatly appreciated.
Screen Shot 2022-12-18 at 7.27.56 PM.pngScreen Shot 2022-12-18 at 7.28.23 PM.pngScreen Shot 2022-12-18 at 7.29.04 PM.png

0 4 214
4 REPLIES 4
Top Labels in this Space