i'm using three versions in my module, here Actual, Forecast, Budget. i have the actual and budget data available and they can be formula driven. Forecast data should be a manual entry data.
Can any one help me solve how i can pull in the actual and budget data formula driven while i leave the forecast data available for editing all in the single line item .
You can achieve this through "Formula Scope"
Also, your Forecast version should be the Actual Version.
Check this link for more info,
If your formula is for numeric values only and you need discrete formulas per version (so a different one for Actual, Budget, Forecast, Plan etc.), then you can use Version Formulae
You need to create a line item subset from the line items in the module, but it is very effective at reducing the number of IFs in the formula
See this article for more details: