2 Replies Latest reply: Apr 20, 2017 11:24 AM by pavan kumar RSS

    Forecasting the sales

    naveen kumar

      Hello ,i need help in writing a expression ,let say i got data

       

       

      Item       month             spend

       

      A             Jan                 1000

      A              Feb                 500

      A              Mar                 1500

      B              Jan                 2000

      B             Feb                    0

      B              Mar                 1000

       

      According to above table A had spend 1000 every month on averages so  for the rest of months on Average he will spend 9000

      so i need to Estimated spend value for balance period for that year which is Apr, May June........Dec

      which results like this for

      item               spend

      A                      9000

      B                       9000

       

       

      Thanks

      Naveen Kumar Kunuru