List box as filter vs filter in code?

[Anonymous]

Hi,

I have a filter in a chart like the following:

= count({$<[Request Status]={'Work in Progress','Monitor',' '}>} DISTINCT [AutoID]) 

Also I have a list box filter for that field, the problem is that as the code inside the chart will include these 2 values, if I use the filter it won't apply in that chart. For example, if I use the list box filter for Request Status], and select "Work in Progress" I want that the chart only displays the "Work in Progress" records. Based on the expression it's not working.

Is there a way that the filter outside the chart will affect this chart besides the code inside?

[sunny_talwar · Accepted solution]

Try this

=Count({$<[Request Status] *= {'Work in Progress','Monitor',' '}>} DISTINCT [AutoID])

Implicit Set Operators