I have a column of numbers. I need a running sum of the previous 7 rows unless there is a zero>then I need to restart at 0.
Anyone have an idea or direction to point me in? Thanks in advance for your help.