Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel1908
Creator
Creator

Count/If/Age Expression

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?

 

2 Replies
Digvijay_Singh

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)

Daniel1908
Creator
Creator
Author

Thanks for your help