wnorwood
Contributor III
2012-09-27
01:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
231 Views
1 Reply
wnorwood
Contributor III
2012-09-27
01:20 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Finally! Answered my own question... here is how I got there:
=sum( {$<test = {">=$(#=Max(test)-3)<=$(#=Max(test)-1)"}>} Sales)
163 Views