0 Replies Latest reply: Apr 18, 2013 7:56 AM by Zhenya Virina RSS

    Forecasting 12 month

      Hi -

       

      I have not used the forecasting feature that QV offers and i was hoping you can help with the following sneario.

       

      I am looking to build a report that will project monthly sales. If I was to build this out in a simple excel formula, it would look like something like this:

       

      Fiscal Period     Total Sale  Forecasting Formula Period 2 2013 Period 3 2013 Period 4 2013

      Period 1 2013      120.00        120/12=10                           10.00          10.00            10.00 etc

      Balance             120.00                                                  110               100             90 etc  

       

       

      Please help, thank you!