I understand what you’re looking to accomplish. Unfortunately BEx isn’t very flexible. It requires all of the data be present for calculations like the one you’re looking to accomplish. A workaround may be to add the missing years with a corresponding value of 0.
I’m not aware of a way to just focus on a calendar year range rule within a calculation. That’s why I mentioned pulling in the missing years to satisfy the requirement, but if that’s not an option I understand. I wish I could be of more help on this but these types of calculations are outside the scope of the BW305 training.