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!