I want to calculate a running cumulative total over time. The dataset has zeros (0) in it so there is a flat spot when I plot cum vs. time. There is a flat spot because I have the same value that is generated due to the zeros.
I have created a calculated column that if the value = 0 then it returns blank() but when I calculate the cums with the equation below I still get a flat spot.
What I am trying to accomplish is a cumulative column that removes the zeros and shifts up, so there isn’t a flat spot of a blank space in the cumulative curve when plotted vs time.
The attached might clear up any confusion.
Can someone please point me in the right direction?