Filter

[Alwin21]

i want to create a filter.. where the category is equal to "ADPR", "CURE", "RNST", "VCTG" "PDSC".... however in the PDSC category.. i wanted to select only the "Plan completion in the docket text field

[Category] IN ("ADPR", "CURE", "RNST", "VCTG") OR [Category] = "PDSC" AND Contains([Docket Text],"Plan Completion")

the above expression only displays the  PDSC... the other category didn't show up. Thank you

[binu_acs]

@Alwin21 your filter condition seems to be correct , can you upload some sample data to verify ? 

[Luke_C · Accepted solution]

Hi @Alwin21 

Try the below (put quotes around the OR). This assumes the docket text condition only applies to PDCS categories.

[Category] IN ("ADPR", "CURE", "RNST", "VCTG") OR ([Category] = "PDSC" AND Contains([Docket Text],"Plan Completion"))

[Qiu · Accepted solution]

@Alwin21 
I have tested the solution of @Luke_C as below.
also we can try a more straightforward formula 😁

[NikyN · Accepted solution]

Hello there,

your filter is almost correct but need additional () -- see below.

The second condition where you filter on category, and at the same time on the Docket Text -- those two must be in extra brackets (solution also attached).

[Category] IN ("ADPR", "CURE", "RNST", "VCTG")
OR
([Category] = "PDSC" AND Contains([Docket Text],"Plan Completion"))

Please let me know if it works for you!

Best luck!

Niky