topic Re: Select empty field not possible in App Development

Select empty field not possible

Daniel1908 — Tue, 30 Mar 2021 06:27:48 GMT

Hello Together,

I added the below and it works, except of the [Request]-={'X'}.
The empty fields from "Request" are not selectable, I guess this is the problem.
Any Ideas how to make them selectable?

=Count( {<[Price]*={"<=100"},[Request]-={'X'},Productkey={'TH',"LR"},[ReturnLabel.]-={'A','B'}, Material= {"6*"}>}[Product Number])

Kind Regards,
Daniel

Re: Select empty field not possible

tresB — Tue, 30 Mar 2021 06:58:29 GMT

I assume that by empty you mean null. If so, then you are right - we can't select NULL value. The work around in set analysis to include null values would be something like:

Sum( {1-<Field={"*"}>} Sales)

I.e. - excluding all possible values from the field from the entire set. In your expression, you could try like:

=Count( {<[Price]*={"<=100"},Productkey={'TH',"LR"},[ReturnLabel.]-={'A','B'}, Material= {"6*"}>

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

Re: Select empty field not possible

Daniel1908 — Tue, 30 Mar 2021 08:08:25 GMT

Unfortunately the system did not take the formula, any other ideas?

Re: Select empty field not possible

tresB — Tue, 30 Mar 2021 08:48:23 GMT

Oh, I can see a mistake in brackets in my previous expression. Try correcting it like:

=Count( {<[Price]*={"<=100"},Productkey={'TH',"LR"},[ReturnLabel.]-={'A','B'}, Material= {"6*"}>

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

Re: Select empty field not possible

Daniel1908 — Tue, 30 Mar 2021 11:25:39 GMT

Perfect, now it works.

Thanks for your help.

Re: Select empty field not possible

Daniel1908 — Wed, 31 Mar 2021 09:31:23 GMT

Hi,

I just recognized, that it is possible to select a Product Key which is not in the formula. This doese not effect the table but the bar graphs. Any Idea if this can be avoided?

Additionally I would like to take out Material beginning with 6TZ8* and Returnlabel "C".

Already set Material = "6*"

Thanks in advance.