OR Function in the expression

[Daniel1908]

Hello together, 

I am using the below expression, this works fine. 
Now I want to add an OR Function with different details (Product=AD,Status=LR3,Text does not include *Spare* or *New*.

=Count( {<Product={"AR"},[Status]={"LR2","LR1"},Text-={"*Spare*","*New*"}>}Materialnumber)

I have a filter problem as well, currently it is not possible to select the text. 
If I put an * before the =  it works, but only without the -. 

Text*={"*Spare*","*New*"}

Any Idea how to get this solved?

Kind Regards, 
Daniel

[salonicdk28]

Try this once-

=Count( {<Product={"AR"},[Status]={"LR2","LR1"},Text=e({<Text={"*Spare*","*New*"}>})>}Materialnumber)

[MayilVahanan · Accepted solution]

Hi @Daniel1908 

Try like below

=Count( {<Product={'AR'},[Status]={'LR2','LR1'},Text-={"*Spare*","*New*"}>+

<Product={'AD'},[Status]={'LR3'},Text-={"*Spare*","*New*"}>}Materialnumber)

[Daniel1908]

Hi Mayil, 

this works, thanks for your help. 

Kind Regards, 
Daniel