AnsweredAssumed Answered

Overlap Calculation

Question asked by chrisyanmanalu on Jul 26, 2018
Latest reply on Jul 27, 2018 by breuber

Hi All,

Please help me how to get my "End Stock from week 27" and will be place to "Opening Stock week 28"

Formula to get Opening Stock   = If (Demand last last week is 0 then get Opening Stock last week else get End Stock)

Formula to get End Stock          = Opening Stock + Incoming - Demand

 

Outcomes