Set Analysis with <=

wnorwood — Thu, 27 Sep 2012 17:11:45 GMT

How can I make the following a <= the Max(Year)-1??

sum( {$<Year = {$(#=Max(YearMonth)-1)}>} Sales )

Or, to be more precise, I am trying to get to >=Max(Year-3 and <=Max(YearMonth).

Any assistance is appreciated!

Thanks.

Re: Set Analysis with <=

wnorwood — Thu, 27 Sep 2012 17:20:46 GMT

Finally! Answered my own question... here is how I got there:

=sum( {$<test = {">=$(#=Max(test)-3)<=$(#=Max(test)-1)"}>} Sales)