Though not quite understand the logic of [Weight] calculation,
anyway have a try at changing [Prod to reach goal] table calculation computing using Table (across).
Thus you will get [Prod to reach goal] decreasing with the increase of day.
Hope this meets your requirements.
Ok, lets forget about the weight right now, and concentrate on the basic requirement. Once we have the calculation right, we can see if the weight have some relevance to it or not:
We have daily productivity numbers, which consist of a few vessels moving a certain amount of containers, for so many hours, and productivity is calculated in Moves per Hour (MPH). For this month, let's say the target is 52 average MPH. And is the 28th, so there are still 2 days left in the month. If the current average of all daily MPH numbers is say, 50.8, I need to calculate how much MPH I need to do in the following two days to reach the goal of 52 MPH.