Filter not throwing any value

[Amy123]

Hi Team,

[Balance*] = "R" AND [Cat] = "1" OR "2" OR "3" is now throwing any value ..please help 

i want to filter balance if its R and Cat 1 ,2 ,3 

[Jean-Balteryx]

Hi @Amy123 ,

I think you should use the following expression as Cat can have many values :

[Balance*] = "R" AND [Cat] IN ("1", "2", "3")

[atcodedog05]

Hi @Amy123 

Try something like this to Cat is present in list of values.

[Balance*] = "R" AND [Cat] in ("1", "2", "3")

Hope this helps : )

[Emil_Kos]

Hi @Amy123,

Please try this formula:

[Balance*] = "R" AND [Cat] IN ("1","2","3")

I will check if the value is in this particular range. 

Please keep in mind that the value needs to be a string if you put numbers in quoutes.