How to Add sum of rows to a new column.

[tarunIMDG]

I am trying to figure out the below -

Need to insert the sum two rows to a new column. Attached is the sample data with expected result and calculation -

[Qiu]

@tarunIMDG 
If I understand correctly, we are looking at a RunningTotal Tool. 😁

[Alteryx_AR · Accepted solution]

@tarunIMDG You can also use multirow formula tool.

 Hope this helps you :)

[tarunIMDG · Accepted solution]

---

@Alteryx_AR wrote:

@tarunIMDG You can also use multirow formula tool.

 Hope this helps you :)

---

Yes.. it definitely worked and saved a lot of time from creating joins. But I am facing one more problem after using the multi-row formula.  In the row highlighted.. the running total should be 9.48 but its giving me zero. Do you know why is this happening or any way to solve that? (see screenshot attached)

The row 11 should give me 9,48 while row 15 and row 16 should give me 240.94 

[tarunIMDG]

.

[binuacs]

@tarunIMDG as @Qiu mentioned Running Total is a good option in this usecase