Provision to enter data in specific version in Report

Hi,

I need to create a report with 3 versions actual,forecast,budget and the data is formula driven. But need to give provision for the planner to override the data only in forecast version which is calculated.Need few suggestions to implement this.

Regards,

Sri Nitya

Accepted answers

All comments

anand.shekhawat

Hi @SriNitya ,

I presume that you have written the formula for the line Item

Now follow the below steps to achieve the functionality.

Step 1) Go to the blueprint view and set the formula scope to Actual Version in the line item.

(Now the formula is only applicable to the actual version of that line item. Budget version will be fully editable and forecast version will be editable from the switchover date)

Step 2) Now go to the versions tab, and set 'None' in the 'Edit From' and 'Edit To' fields for Budget version. Or you can set as per your requirement, making sure that 'Edit From' and 'Edit to 'time duration does not overlap the user input time duration.

I hope it helps

~Anand

SriNitya

Hi Anand

Thanks for reply,

But I am not using Anaplan inbuilt versions, I have created versions as a list and only forecast version needs to be editable.

Regards

Srinitya.M

abhi1017

Hi @SriNitya

I guess this can be achieved by filter based DCA.

1. Create another lineitem override forecast.

2. This lineitem should be only be editable when forecast version is selected.

3. Apply DCA on this lineitem. Create another lineitem(boolean formatted) say Forecast edit :- If Item(version)= Actual or item(version) = budget then false else true.

4. Apply this in override forecast lineitem in Write section.

5. Create a final lineitem where data is aggregated/pulled from the primary and override lineitem.

~ABhi

anand.shekhawat

Hi @SriNitya,

If you are using created versions, then follow the below steps.

Step 1) Create two new line Items , Override?(boolean) and Override Value(number)

Step 2) Write a formula in the line item for which you want to override the forecast version for

IF NOT Override? THEN {Original formula} ELSE Override Value

Step 3) Now check and uncheck the forecast version of the 'Override?' line item to achieve your functionality

I hope it helps

~Anand

Quick Links

Can you help?

Unanswered questions

Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…