Projected Stock Calculation

[Munjal]

I want to calculate Projected Stock column as per below table. 

Product	Month	Demand	Supply	SOH	Projected Stock	Projected Stock Formula
A	2024|01	2000	1500	5600	5100	5600-2000+1500
B	2024|02	3000	2000		4100	5100-3000+2000
C	2024|03	4000	3000		3100	4100-4000+3000
D	2024|04	5000	6000		4100	3100-5000+6000

Need to calculate this Projected stock for future 36 months and months will keep changing on rolling basis each cycle. 

Is there any good way to achieve this in Alteryx?

[gawa]

hi @Munjal 

You can use Multi Row Formula tool like this.

[flying008]

Hi, @Munjal 

FYI.

IIF(IsEmpty([Row-1:Projected Stock]), [SOH] - [Demand] + [Supply], [Row-1:Projected Stock] - [Demand] +[Supply])

[aatalai]

The time series tool might also help (if you are looking for non forumla/model approach)

[chaitanyaiys1]

HI