List and in expression not working

Adam_Grunys
Participant III

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 443
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

Is your [role] column an EnumList?

Yes it is.

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

Rightโ€ฆ Thanks so muchโ€ฆ Works great!

Youโ€™re welcome

Top Labels in this Space