topic Re: OR Function in the expression in App Development

OR Function in the expression

Daniel1908 — Wed, 02 Jun 2021 08:03:23 GMT

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

Re: OR Function in the expression

salonicdk28 — Wed, 02 Jun 2021 09:12:38 GMT

Try this once-

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

Re: OR Function in the expression

MayilVahanan — Wed, 02 Jun 2021 09:13:33 GMT

Hi @Daniel1908

Try like below

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

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

Re: OR Function in the expression

Daniel1908 — Wed, 02 Jun 2021 14:24:56 GMT

Hi Mayil,

this works, thanks for your help.

Kind Regards,
Daniel