Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
Thanks for your help