Forum Discussion
LucasFiorini
4 years agoNew Member
Check if value is in a List
Hello everybody!
How can I find out if one of the selected values is a string?
What I tried out:
VAR SelectedKpi = SELECTEDVALUE(KPIs[Value])
return
IF(SelectedKpi IN {"SOE"},SUM(...),BLANK())It works, but I select multiple values, it will only work for one at a time.
I would like to be able to check if the string is into that variable.
Thanks!
You can put many values inside {...}, like {"A", "B", "C"}.
2 Replies
- daXtreme
Solution Sage
You can put many values inside {...}, like {"A", "B", "C"}.
- AnonymousNot applicable
Hi LucasFiorini ,
I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin Yu