List and in expression not working

Hello, would any be able to tell me why this in() expression is returning N.

I cant seem to understand why.

Thanks

Solved Solved
0 5 445
1 ACCEPTED SOLUTION

When your [role] column is EnumList, itโ€™s a list already and you should use it likeโ€ฆ
IN(โ€ฆ,[role])

View solution in original post

5 REPLIES 5
Top Labels in this Space