2 Replies Latest reply: Jun 12, 2009 3:41 AM by Amir Vastani RSS

    Set Analysis Multiple Range Search

    Amir Vastani

      I saw a post on set analysis with range search posting the answer as


      SUM({$<MOTRenewal={">$(=Today())<=$(=(Date(Today()+14)))"}>} FieldToAggregate))

      My question is what if I have multiple date ranges that are not continuous. Do I just use a comma to separate and add the other ranges or do I have to do a + SUM() with the other ranges?

      thanks in advance