0 Replies Latest reply: Feb 21, 2013 10:48 AM by Janne Vauhkonen RSS

    How to split monthly volume for two days within one month?

      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 codeSales forecast March
      1111110000
      2222210000
      3333310000

       

      Desired table: 60% in 10th day and 40% in 20th day

       

      Product codeSales forecast in March 10thSales forecast in March 20th
      1111160004000
      2222260004000
      3333360004000

       

       

      Thanks

      Regards

      Janne