Aggregate prior row data and show in an another column.

[Spatel68]

Hi,

I am trying to sum values from each preceding row and show the running total in an additional column

eg:

Year    Amount    Total

2000      100         100

2001      150         250

2002      200         450

2003      100         550

2004      175         725

Target is to auto generate the Total column when Year and Amount are given.  I am able to do this using Multi-Row Formula tool, but the I have to hard code the expression based on number of records (5 in this case).  There has to be a way to automate this. Meaning the Total get dynamically generated instead of me changing the expression every time the records count changes.  Need some advice.  Thank you

[JosephSerpis · Accepted solution]

Hi @Spatel68 the running total tool might help you in this case. You can also make the expression in the Multi-Row tool dynamic. See the attached workflow where I mocked up a couple of examples. 

[Spatel68 · Accepted solution]

Thank you Joseph Serpis. I thought of running total but some reason it didn't work in my actual situation.  I see it works fine in this simplified model.