Waterfall Subtraction Formula

[jgarcia0417]

Hi everyone,

I'm working on a workflow where i'm automating a waterfall logic. 

I hit a snag on the subtraction part, do you know any way to recreate this excel logic within Alteryx? - the output will always be 5 rows so if its static its fine.

I've attached a sample workflow too 

Thanks! :)

i was thinking maybe a formula tool tied to a record ID? - dont know how to execute to modify each row of data though. 

[BrandonB · Accepted solution]

You probably want to use a multi-row formula with some logic like this:

[jgarcia0417]

You're awesome thanks again!!