Running total of two columns along with opening balance

[caneerajdwivedi]

Hi all,

I've an opening number of 100 employees and monthwise movement is as below :

Month	Joiners	Leavers
Apr	10	0
May	11	-1
June	12	-2
July	13	-3
Aug	14	-4
Sep	15	-5
Oct	16	-6
Nov	17	-7
Dec	18	-8
Jan	19	-9
Feb	20	-10
Mar	21	-11

So my desired output is For april is Opening (100) + Joiners (10)+Leavers (0) =110 and so on as below :

Month	Joiners_Count	Leavers_Count	Running balance
Opening			100
Apr	10	0	110
May	11	-1	120
June	12	-2	130
July	13	-3	140
Aug	14	-4	150
Sep	15	-5	160
Oct	16	-6	170
Nov	17	-7	180
Dec	18	-8	190
Jan	19	-9	200
Feb	20	-10	210
Mar	21	-11	220

How can i achieve the same in alteryx ?

[RolandSchubert · Accepted solution]

Hi @caneerajdwivedi ,

I think, the Multi-Row Formula tool could do the job.

I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland