SOLVED
Reverse Running Total
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
Adam_P
5 - Atom
‎01-30-2020
02:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Apologies for what I am sure is a easy question (that I can't seem to find an answer to).
I am looking to do a "reverse" running total in Alteryyx. I have a series of cashflows per month and need to sum the future cashflows for each particular month to obtain a balance outstanding.
Anyone have any suggestions as to how to calculate the Total Cumulative Sum in the table below.
Month | Monthly Cashflow | Total Cumulative Sum |
Jan-19 | 100 | 1200 |
Feb-19 | 100 | 1100 |
Mar-19 | 100 | 1000 |
Apr-19 | 100 | 900 |
May-19 | 100 | 800 |
Jun-19 | 100 | 700 |
Jul-19 | 100 | 600 |
Aug-19 | 100 | 500 |
Sep-19 | 100 | 400 |
Oct-19 | 100 | 300 |
Nov-19 | 100 | 200 |
Dec-19 | 100 | 100 |
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
3 REPLIES 3
15 - Aurora
‎01-30-2020
03:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-30-2020
03:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Perfect. Thanks for that.
Brian_S
5 - Atom
‎01-03-2022
01:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
