Forum Discussion

LucasFiorini's avatar
LucasFiorini
New Member
4 years ago
Solved

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's avatar
    daXtreme
    Icon for Solution Sage rankSolution Sage

    You can put many values inside {...}, like {"A", "B", "C"}.

  • Anonymous's avatar
    Anonymous
    Not 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