Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
that does the trick