Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Together,
I am looking for a solution to count the Product Numbers which have Product Key TH or LR, not having the Return Label A or B, Material beginning with 467* if the price is <=100€.
=Count({<Productkey={'TH','LR'},[ReturnLabel.]-={'A','B'},Material={'467*'}>}if([Price]={"<=100€"},Product Number))
Thanks for your help.
Kind Regards,
Daniel
Hello @Daniel1908 ,
What's wrong with your exp?
Anyway you could try the below:
=Count( {< Productkey = {'TH','LR'},
[ReturnLabel.]-={'A','B'}, Material = {"467*"}, Price = {"<=100"} >} [Product Number] )
I hope it can helps.
Best Regards
It did not work correctly.
This works fine, thanks.
I tried to add another criteria, just show empty fields (-) from column Request.
Unfortuately It doesn't work, do you have an idea?
[Request]-={'X'}
Kind Regards,
Daniel