2 Replies Latest reply: May 21, 2017 7:12 AM by Stefan Wühl RSS

    Calculation for prediction

    Shirin Akhshijan

      Hello,

      I need help regarding prediction values. I describe my case briefly :

      I have some TestObject and their Estimatedvalue are calculated. then from the value they can be sell in one or two steps with estimated efficiency.

      Then I want to have the predicted sale in future by sum (Estimatedsale*EstimatedValue) in each month from different TestObject and plot them.

       

      TestObjectEstimatedValueEstimatedsale1EffectMonthEstimatedsale2EffectMonth
      A7,20,82017-040,22017-07
      B60,32017-060,62017-09
      C8,10,52017-090,4
      D8,50,72017-050,2
      E40,62017-060,42017-09
      F5,70,52017-060,32017-07
      G7,80,42017-090,4