Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Together,
I want to count the Material Numbers beginning with 6*, but exclude the ones beginning with "6TZ8*"
=Count( {<[Price]*={"<=100"},Productkey*={'TH',"LR"},[ReturnLabel.]-={'A','B'}, Material= {"6*"},Material-= {"6TZ8*"}>
This does not work, any ideas?
Thanks in advance.
Daniel
Maybe like this:
=Count({<[Price]*={"<=100"},Productkey*={'TH',"LR"},[ReturnLabel.]-={'A','B'},Material= {"=if(Wildmatch(Material,'6TZ8*')=1,Null(),Material)"}>}if(Wildmatch(Material,'6*')=1,Material))
The Formula shows OK but my expression afterwards doese not work anymore
*(1-<[Request]={"*"}>)}[Product Number])