Hi Everyone,
I need to check a particular word (multiple words) in a long string.
Eg. My strings are
Total sale for product Asft is 34
Total sale for product A9ft is 0
Total sale for product Asorft is 3
Total sale for product QASXCD is 4
Total sale for product PMJNHY is 74
Total sale for product yhjuik is 344
Total sale for product awdsft is 3674 ...
I have to take count of Asft sale - Count({<Product={"*Asft*"}>}ID) //Working fine
Now i need to exclude 2 products(Asft,A9ft) and need to find count of other 5
Count({<Product - ={"*Asft*"}>}ID) //this will exclude only Asft
How to give multiple values in set analysis instead of writing multiple times same condition like below
Count({<Product - ={"*Asft*"}, Product -={"*A9ft*"}>}ID)
