Populate a Forecast

Highlighted
Previous Contributor

Populate a Forecast

Hi everyone, This will be an easy one : What is the easiest way to populate a "forecast"'s version for 2015 based on the "actual 2014" and a constant ratio ? Regards

2 REPLIES 2
Highlighted
Group Leader - Employee

RE: Populate a Forecast

It depends on model details If you use 2 years timescale (2014 & 2015) and build a module with versions (Actual&Forecast) you could have steps as below: 1. For target lineitem (let's name it Sales) you change formula scope to All versions except actual 2. You upload actuals to actual version 3. You build formula - POST(sales[SELECT: VERSIONS.Actual], 12)*rate%
Highlighted
Frequent Contributor

RE: Populate a Forecast

If you're looking for the formula to calculate that version model-wide, you can also use a formula in the versions in the Settings Tab (Settings -> Versions -> Formula).