Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
wnorwood
Contributor III

Set Analysis with <=

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.

1 Reply
wnorwood
Contributor III
Author

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

 

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