Reverse Cumulate Alternative?
Hi - hoping to see if anyone has a solution to this:
In the following example, I'm trying to calculate (going backwards) when the sum (less current period) would be greater than the test doh line item.
In Jan 20, it would look back 3 periods to be greater than or equal to 92. (Oct/Nov/Dec)
In Mar 20, it would look back 4 periods to be greater than or equal to 92. (Nov, Dec, Jan, Feb)
I have tried various forms of CUMULATE, OFFSET, PREVIOUS... but haven't been able to create this logic.
Has anyone had success performing a reverse recursion?
Thanks in advance!