How to check if a string is in a string list using calculated fields?

Question & Answer
, , ,
1

Hello All, I am attempting to filter my analysis based on a Parameter string list, and map it to different fields in a row of a table. I am attempting to create a filter for multiple items based on an id without duplicating rows. I saw that using multi-select parameters in calculated fields was not supported from Jun 2022, so I was wondering if there is a way to check if a string is in a string list within a calculated field similar to inArray or IN () syntax. Thanks

2

Hi @dclutes3

You are right. The IN is what you use to find a value in a String List. I attended a learning session yesteday that covers a pretty useful and practical example using multi-value parameters.

I have provided the link below to the video. Hope it helps you get your calculation working.

Regards,
Giri

3

Hi @dclutes3,
It’s been awhile since we last heard from you, did you have any additional questions or were you able to use the suggestion above to find a solution?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @dclutes3,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information if needed.

Thank you!