SOLVED
Calculate Compounding Amount of People/ Email Sends
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
kpontarollo
8 - Asteroid
‎11-18-2022
10:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
4 REPLIES 4
17 - Castor
‎11-18-2022
10:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
16 - Nebula
‎11-20-2022
12:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
17 - Castor
‎11-20-2022
08:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ShankerV
17 - Castor
‎11-20-2022
08:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
