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




      Naveen Kumar Kunuru