Math in the first row and the take that total and carry it over into the next row...

[lconnolly]

Hi there,

I need to be able to do math in the first row and the take that total and carry it over into the next row... and so on and so on. Can anyone please help?

[Qiu]

@lconnolly 
I think a Multi-row formula is what you are looking for here.

[ericsundby]

A multi-row formula tool seems to be the solution. I've attached a workflow with the first 4 records of the data in your screenshot that accomplishes this using a multi-row formula tool. Also, if you left click on the multi-row formula tool in the preparation tab and click on "show example", you will see several examples of how it works.

[lconnolly]

Let me try to explain it a different way:

USED LOC + INBOUND - OUTBOUND = USED LOC X

USED LOC X + INBOUND - OUTBOUND = USED LOC Y

USED LOC Y + INBOUND - OUTBOUND = USED LOC Z

.

.

.

AND SO ON

I tried this, but I am not getting what I am looking for:

Thanks for your help.

[ericsundby · Accepted solution]

Thanks for the clarification. I've attached a screenshot of the corrected formula, and the updated workflow as well. 

[lconnolly]

Thank you!