Set Analysis Multiple Range Search

[avastani]

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

[johnw · Accepted solution]

I believe you just use a + to do the union of two different sets of values, like this:

sum({<MOTRenewal={">=$(=start of first range) <=$(=end of first range)}
+{">=$(=start of second range) <=$(=end of second range)}>}FieldToAggregate)

[avastani]

that does the trick