topic Count & Exclude a Field beginning with the same Number in App Development

Count & Exclude a Field beginning with the same Number

Daniel1908 — Thu, 01 Apr 2021 13:56:13 GMT

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

Re: Count & Exclude a Field beginning with the same Number

Frank_Hartmann — Thu, 01 Apr 2021 14:20:12 GMT

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))

Re: Count & Exclude a Field beginning with the same Number

Daniel1908 — Thu, 01 Apr 2021 15:06:38 GMT

The Formula shows OK but my expression afterwards doese not work anymore

*(1-<[Request]={"*"}>)}[Product Number])