Select empty field not possible

[Daniel1908]

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

[tresesco]

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

[Daniel1908]

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

[tresesco]

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

[Daniel1908]

Perfect, now it works. 

Thanks for your help. 

[Daniel1908]

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.