Thanks for the solution. While it wasn’t exactly what I was looking for we were able to get where we needed. After examining your formulas we realized we were very close. We calculated it using your method and we added an Index, but later discovered it was even more simple than that:
Window_sum(sum(, -5, -3)
This formula worked perfectly.
Thanks again for the quick response!
image001.png 8.9 KB
1 of 1 people found this helpful
Great! I'm glad you found the answer!
Would you mind marking an answer as correct so it closes the thread?