IN expression not working as desired

[AlfredoChavez]

Hi!

This might be super simple but I can't figure out how to use the IN expression. I created a list using SELECT and I want to check wether it contains a specific value. This is the list. I put the expression in a random table to be able to test the logic.

I tested all of the elements in the list, and checked for any additional spaces. 

Any idea what could be wrong?

Thanks a lot!

[Marc_Dillon · Accepted solution]

Is [Acceso a vistas] an EnumList?

If so, your SELECT result is actually a list of lists. You need to flatten it out like this.

IN( xx , SPLIT( TEXT( SELECT(...) ) , " , " ) )