Hi
I am trying to build a forecast report for accounts receivables. My sales forecast is only on monthly level and I would need to split that at least to two pieces. What kind of script I would need to write in following scenario:
Original table:
| Product code | Sales forecast March |
|---|
| 11111 | 10000 |
| 22222 | 10000 |
| 33333 | 10000 |
Desired table: 60% in 10th day and 40% in 20th day
| Product code | Sales forecast in March 10th | Sales forecast in March 20th |
|---|
| 11111 | 6000 | 4000 |
| 22222 | 6000 | 4000 |
| 33333 | 6000 | 4000 |
Thanks
Regards
Janne
