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!
Solved! Go to 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(...) ) , " , " ) )
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(...) ) , " , " ) )
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
16 |