Hi,
I would like to distribute the total forecast value based on the actual contribution as well as the user defined contribution.
I have Prod category A,B,C having sales 100,300 and 50, their contribution is 22%,67% and 11% respectively.
user will input the total forecast sales as 1000, than distribute the total based on the actual contribution. Lets say, now user wants to overwrite the prod category A to 25%, than Prod Cat A to 250, remaining 750 will be assign to the actual proportion to B and C.
| Prod | sale | % Contr | Forecast | Forecast |
| | 450 | 1 | 1000 | 1000 |
| A | 100 | 0.222222 | 222.2222 | 250(1000*25/100) |
| B | 300 | 0.666667 | 666.6667 | 642.857143(750*(300/(300+50) |
| C | 50 | 0.111111 | 111.1111 | 107.142857(750*(50/(300+50) |
Similarly, if the user input 25% to A and 50% to B than assign remaining to C. users will input the A,B and C values in different combinations.
Thanks in advance.
