The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more 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