Multi-row formula

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.

Expression

Accepted answers

markcurry

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

Create Cumulative Sum.yxmd

All comments

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703