Reverse running total in a column should starts from -ve values and end once

[Anonymous]

Hi All,

I need help for doing revrese cumulative total for column having -ve values. Please check the below data and explanation on exactly what I needed.

STDate	Load	Index	Output
10 August 2020	1000000	1	1000000
11 August 2020	2000000	2	1000000
12 August 2020	3000000	3	-1000000
13 August 2020	4000000	4	-4000000
14 August 2020	-8000000	5	-8000000
15 August 2020	6000000	6	6000000

In above table 1st three columns are actual data and output column is expected output. Calculation in output column is rverese running total for only neagtive values in load column based on STDate column order. Here running total starts from -800000+4000000+3000000+2000000 and running total should be stop up to the value become positive. In above table revrese running total starts from index 5 to index 2 where it becomes positve at 1000000 of index2.
  So please help me in achieving the output column as expected.

Thanks

Praneeth

[v-yuta-msft]

@Anonymous ,

---

Here running total starts from -800000+4000000+3000000+2000000 and running total should be stop up to the value become positive.

---

Could you please clarify more details about the logic you mentioned above?

Regards,

Jimmy Tao

[Anonymous]

Hi Jimmy,

we have a load column actual data output column is expected one. In load column we have negative value -8000000 and that value should be add to previous row vaue 4000000 then it becomes -4000000 and again it should be add to previous value 3000000 then it will become -1000000 again it should be add with 2000000 and then it become 1000000 and now i should be stop the adding to previous value because now it is positive. Finally if there is -ve value in a column it hsould be add to previous row values upto it become positive