Calculate Compounding Amount of People/ Email Sends

Question

Hi All,

I am looking to see if there is a way to build the following into alteryx, like I did in excel. Column E & F are the sum of the cell above it and the cell to the left of it. For example, E5 = E4 + D5. I added a screen shot of my excel sheet as well.

image.png

DataNath · Accepted Answer

Hey @kpontarollo, there is a Running Total tool in Alteryx. To mimic column E you would just bring that in and choose [Total] as your column to sum. Likewise for re-creating field F, you would bring on another running total tool and select the field that was created in the previous one to sum.

Felipe_Ribeir0 · Accepted Answer

Hi @kpontarollo

You can use the Multi-Row formula tool in a way very similar to the way that you are using excel for this:

ShankerV · Accepted Answer

Hi @kpontarollo

One way of doing this to reach the solution,

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @kpontarollo

Step 1:

Step 2:

Step 3;

Many thanks

Shanker V