Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this script that gives me count of various product categories containing nut and fruits. I need to adjust it to give me count of either Nut or Fruit. Please advice.
if(Wildmatch([Product],'*Nut*','*Fruit*')
OR Wildmatch([Liq Products ],'*Nut*','*Fruit*')
OR Wildmatch([Matched Products (All)],'*Nut*','*Fruit*'),
'Has Fruit and nuts', 'Does not have both') as Product_Flag
Isn't that what it is doing? Can you share an example where it didn't work?
The output is count of products containing both nut AND fruit, but i want a situation where the script would return either nut OR fruit
I think the script should be returning the result as an OR condition and not as an AND condition.
So in that case my output should be labelled as
if(Wildmatch([Product],'*Nut*','*Fruit*')
OR Wildmatch([Liq Products ],'*Nut*','*Fruit*')
OR Wildmatch([Matched Products (All)],'*Nut*','*Fruit*'),
'Has Fruit or nuts', 'Does not have nut or fruit') as Product_Flag
Is that correct? Or how should it read? I'm confused.
I got the same errors as well. Do you have any idea how to solve it?
Hi,
why can't you use like this for counting Nut or Fruit
if([Product]='*Nut*', count([Product]))
@Gopi_E wrote: myprepaidcenterHi,
why can't you use like this for counting Nut or Fruit
if([Product]='*Nut*', count([Product]))
I have no idea what i do exactly ?
please explain in detail.