Multi-row formula

[Tim6]

Hi There, 

I am new to alteryx. 

I have alot of rows in my data file.

Is there a way i can use the Multi-row formula to obtain the cumulative sum in each cell by adding the data in the row directly above it? 

Please let me know. 

Thank you.

[estherb47]

Absolutely!!!

[Value]+[Row-1:Value] should do it.

You might also consider the running total tool. It's in the transform
category, and is extremely easy to use.

Let me know if that works. Cheers!
Esther

[Tim6]

Hi Esther - Thank you very much. 

I wrote the formula but for sum reason I don't think alteryx is recognizing my formula it is giving me a NULL back (values for rows that don't exist)

Please let me know what you think.

[markcurry · Accepted solution]

As Esther mentioned, the Running Total is probably the easiest, but here's a workflow with the Running Total and the Multi-Row Tool...