In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Reverse Running Total

Adam_P
5 - Atom

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.

 

MonthMonthly CashflowTotal Cumulative Sum
Jan-191001200
Feb-191001100
Mar-191001000
Apr-19100900
May-19100800
Jun-19100700
Jul-19100600
Aug-19100500
Sep-19100400
Oct-19100300
Nov-19100200
Dec-19100100
3 REPLIES 3
OllieClarke
15 - Aurora
15 - Aurora

Hi @Adam_P this is the easiest way of doing that I could think of

OllieClarke_0-1580426499366.png

 

Let me know if that helps,

 

Ollie

Adam_P
5 - Atom

Perfect.  Thanks for that.

Brian_S
5 - Atom

Not sure of the requirement if the monthly totals vary -- the attached takes care of that.

Labels
Top Solution Authors