Hi All - I think my brain might be mush…. I have an expression that is working well and trying to apply it to another slice but i am getting an error:
Parameter 2 of function IN is of the wrong type
Working expression:
IN(
ANY(
SELECT(team[subteam],USEREMAIL()=[email])),
SELECT(central_category[central_category_groups],in([central_category_name],[_thisrow].[central_category])))
Expression giving an error:
IN(
ANY(
SELECT(team[team],USEREMAIL()=[email])),
SELECT(central_activity_type[central_activity_type_group],in([central_activity_type_name],[_thisrow].[central_activity_type]))))
The only issue is that [central_sub_category] is an ENUMLIST where [central_activity_type] is a ENUM.
Any ideas?
The second argument to IN() must be a list (List or EnumList). An Enum is not a list. Instead of using IN() for [central_activity_type]
, just use =
.
hanks for the tip! couldn’t get your suggestion to work, but wrapped [_thisrow].[central_activity_type] In a List and it works now
You rock!
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |