When creating Forecasts, Futrli Advisor allows you to use the 3, 6 or 12 previous months data to create Forecast Items for specific Accounts. There is no need to create a Formula to calculate this, it can be done using the 'Set Monthly Growth Rate' method (which can be copied to other Accounts) in the Forecast's Forecasting Methods.
Video: Creating a Forecast Item based on the average of the last 12 months, plus a 10% increase
Once in the Forecast in question, navigate to the Account you would like the Forecast Item created against and hit the green plus symbol:
This will bring up the Forecast Item, ready to be created. Select 'Set Monthly Growth Rate' as the method type and enter the Forecast details. You will need to enter an increase/decrease amount, taking into account that you cannot enter zero, 0.01% is the smallest number you can go forward with. You can then select to base calculations on an average of the last three, six or twelve months of data:
Once you save changes, the Forecast will appear against the Account in question. Click on the cog to open the options, which will include the option to copy this Forecast Item to other Accounts: