Projected Stock Calculation

Question

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

ProductMonthDemandSupplySOHProjected StockProjected Stock FormulaA2024|0120001500560051005600-2000+1500B2024|0230002000 41005100-3000+2000C2024|0340003000 31004100-4000+3000D2024|0450006000 41003100-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?

chaitanyaiys1 · Answer

HI

iNFY dATA.csv

aatalai · Answer

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

flying008 · Answer

Hi, @Munjal

FYI.

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