Hello,
I was wondering how to use set analysis to consider the value of another column.
For example.
I want to count all the dates1 that are bigger than their date2.
I was thinking some like:
=count({$<dates1 ={'>=(date2)'}>}dates1 )
But is not working, im not sure why.
Wihtout set analysis i would try to use if like this:
=sum(if(dates1>=date2,1,0))
The problem is that im just learning set analysis and im trying to use it now.
Can anyone help me?
thx
