topic Re: Count If Function in App Development

Count If Function

Daniel1908 — Mon, 29 Mar 2021 10:17:13 GMT

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

Re: Count If Function

agigliotti — Mon, 29 Mar 2021 10:24:51 GMT

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

Re: Count If Function

Daniel1908 — Mon, 29 Mar 2021 13:42:50 GMT

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