Member

Copy data to Derived Cell status

4 replies
24 views

I am trying to build a rule to copy data from one year/Forecast Scenario to another e.g Long term and have req to copy data to derived cell value but dont want data to be enable for input.
Is there way to copy data? I tried DM job and Custom finance rule but it did not work.

Planning

S

sameburn

Employee - Advisor

Hi pranav46

The cells you have highlighted are invalid (pink) which is probably why you cannot write data there

I would check your data model to see why that intersection is invalid in the first instance

Hope this helps

Sam

P

pranav46Author

Member

Sam - Yes I made it invalid so, no one can forecast long term number but idea if I can seed from other scenario and have limited input. Don't want to go to extensibility route.

S

sameburn

Employee - Advisor

Hi pranav46

If your target cells are invalid (pink) in your data model. That means you cannot write data there. So suspect that is your issue

Sam