How would you convert expression to set analysis?

[mrichman]

Hi Community,

How would you convert underlying expression to set analysis?

=count(distinct if(Date2 - Today()>=7, ProductID, Null())) and ignore field name Date1=    ??

Date1 = even if this field is being filter, it will have no effect on the formula.

Thanks in advance. 

[fvelascog72 · Accepted solution]

Hi,

Try with:

=count(distinct {<Date1>} if(Date2 - Today()>=7, ProductID, Null()))

Saludos

[sunny_talwar]

Or this

=Count(DISTINCT {<Date1, Date2 = {"$(='>=' & Date(Today() + 7))"}>} iProductID)

[mrichman]

Thanks Sunny!

[mrichman]

Thanks Federico