2 Replies Latest reply: Jun 1, 2017 12:52 PM by Todd Buss RSS

    basic set analysis woes

    Todd Buss

      This formula shows all records that fall within the latest date in the set:

       

      count({$<[Date Submitted to TC]={">=$(=max([Date Submitted to TC]))"}>}[Date Submitted to TC])


      This formula should show all records that fall within the 7 days prior to the latest date in the set:


      count({$<[Date Submitted to TC]={">=$(=max([Date Submitted to TC]))-7"}>}[Date Submitted to TC])

       

      The first formula works, but the second doesn't.  I've been tinkering for hours trying to get this to work.   Any help would be appreciated.  Thanks.