I am creating a table of forecast according to week.

[#1]

Hello everyone,

I am creating a forecast table for week 1 to 10 in which one of my field Projected stock on Hand is calculated value using Previous Stock+Planned Production+Planned Recieves -  overall Forecast now

Previous Stock  is replaced by (Projected stock on Hand for previous week)

then it will calculate the Projected stock on Hand for next week.

How can we do this?

Thanks and Regards.

[Gysbert_Wassenaar]

Please post an example document. See this document for how to create a small and non-confidential document: Preparing examples for Upload - Reduction and Data Scrambling