Hi All,
Im trying to resolve below issue form a while. Currently im trying to build forecast vs stock calculations to show me weeks of cover. Im not looking for average but to calculate in Wk2 i have stock enough for ... weeks with the forecast value as .... Also include negative stock (to be use in my later calculations). Can someone help me to resolve this as I have spend fare too much time
<tbody>
</tbody>
Im trying to resolve below issue form a while. Currently im trying to build forecast vs stock calculations to show me weeks of cover. Im not looking for average but to calculate in Wk2 i have stock enough for ... weeks with the forecast value as .... Also include negative stock (to be use in my later calculations). Can someone help me to resolve this as I have spend fare too much time
Wk1 | Wk2 | Wk3 | WK4 | WK5 | Wk6 | |||
<tbody> </tbody> | 10 | 230 | 52 | 20 | 50 | |||
<tbody> </tbody> | 200 | 190 | -40 | 60 | 40 | -10 | ||
<tbody> </tbody> | 0 | 0 | 0 | 100 | 0 | 0 |
<tbody>
</tbody>