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
Hi @Amy123 ,
I think you should use the following expression as Cat can have many values :
[Balance*] = "R" AND [Cat] IN ("1", "2", "3")
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 : )
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.