13 Replies Latest reply: Apr 22, 2016 3:02 PM by Sunny Talwar RSS

    Ignore Any Selection

    Jason Liau

      I have the below expression where I am calculating the min count of email address in 60 days but I can't seem to figure out how to ignore any selections on the date fields?

       

      =min(aggr(count({$<[Inquiry Date] = {">=$(=Date(Max([Inquiry Date])-60)<=(=Date(Max([Inquiry Date]))))"},[Inquiry Date]=,[Inquiry Week]=, [Inquiry Month]=, [Inquiry Year]=>}[Email Address]),[Inquiry Date]))

       

      Thanks in advance!

       

      -Jason