I am stuck with a problem. I need to restart the running-sum every-time a 0 is encountered.
eg: I need the running sum to look like the "sum" column below. Is it even possible?
IF SUM([Amount]) = 0 then 0 else PREVIOUS_VALUE(0) + SUM([Amount]) END
Retrieving data ...