Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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!

0 Replies