Set Analysis Question

Thu, 30 Jul 2015 22:03:07 GMT

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

Re: Set Analysis Question

maxgro — Thu, 30 Jul 2015 22:14:06 GMT

maybe at pag. 14 of this pdf doc

MK_QSL — Thu, 30 Jul 2015 22:25:24 GMT

COUNT({<date1 = {"=date1 >= date2"}>}date1)