Calculated field on multiple values filtering control

[Giridhar.Prabhu]

Hi @lbl

Please use the IN function instead of CONTAINS since you are dealing with a Parameter control that is list of strings.

Find below a case where the IN is used. You can adapt your case using this as reference.

Filter with all values selected return no data

Hi @jgrueso Here’s an example of what I mentioned earlier. This is a case from my dataset and you need to adapt it to your case. [image] The IN(NULL, … ) case in my screenshot addresses the situatio where the Select All is done by the user in the parameter. Similar to this you can have a boolean result (1, 0) come out of your ifelse and the where clause only looks for where the result = 1 (True) to filter your records. Regards, Giri

Regards,
Giri