topic Count/If/Age Expression in App Development

Count/If/Age Expression

Daniel1908 — Fri, 03 Sep 2021 09:54:18 GMT

Hello Together,

A am using the below expression, it works fine.
(It counts text which includes bike and excludes Material beginning with 1)

=Count({<[Text]={"=WildMatch(Left(Text,20),'*Bike*')"},
Material=P({<Material={"*"}>}Material)
*E({<Material={"1*"}>}Material)>*(1-<>)}Material)

Now I want to add the below:
It should only count if the beginning date is not >2 Years.

if(age(today(),[Beginning Date])>2,'OK','Nicht OK')

I want to bring this together, but unfortunately it does not work.

Any Ideas?

Re: Count/If/Age Expression

Digvijay_Singh — Fri, 03 Sep 2021 13:12:43 GMT

Something like this may be -

=Count({<[Text]={"=WildMatch(Left(Text,20),'*Bike*')"},
Material=P({<Material={"*"}, [Beginning Date] = {"=age(today(),[Beginning Date])>2"} >}Material)
*E({<Material={"1*"}>}Material)>*(1-<>)}Material)

Re: Count/If/Age Expression

Daniel1908 — Mon, 06 Sep 2021 08:28:49 GMT

Thanks for your help