Dynamic webform with actual and forecast scenarios data

Hi,

I am not sure why you want to have substitution variables, why don't you have scenario as the page with Actual and forecast, then the user can select from the dropdown whether they want to input actual or forecast.

Or is that you want to take actuals up to the current month and then the rest of the months are forecast ? If so you could have a rule that copies the actuals into the forecast scenario.

Cheers

John
http://john-goodwin.blogspot.com/

Well the idea of copying the actuals to fcst scenario is a good one. I have a similar issue currently where i have some actual months combined with FCST months. The problem is actual months must be read only and fcst must be writable. So even though i copy these actuals to Fcst, i cannot prevent users from changing actual months data.
Another solution that i found is to use shared members. Creating a seperate member with chiildrens as months.
I simply define Childrens of the member in the webform. After every month i add a extra child(month) without touching any of the webforms. I have not studied it entirely yet but sounds to be interesting Let me know your views.
Thanx
sam

To prevent users from updating Actuals data, simply change the "start month" and "start year" associated with your given scenario.

- Jake