Dynamic Cells Calculation (DCC)

[damien.bouquier]

This feature would allow to selectively switch between "Calculation" or "Manual Input" on a specific LineItem.

Much like the DCA, the DCC would be based on a boolean. When True, the formula would apply but when False the user would be allowed to type data.

This would allow to make Anaplan much more dynamic and greatly limit the number of actions in most models.

For example, in the same LineItem "Revenue" could be based on :

• a transactional actual data before a switchover,
• manually type for the current year,
• and calculated based on a kpi in the futur.

[Farooqkamal1]

This would be a great addition. At this moment, we are limited to choose between a formula line item or a editable line item. 

[Axel_H]

I came up with a similar idea about 1.5 y ago but did not get much traction:

https://community.anaplan.com/t5/Idea-Exchange/Formula-Access-Driver/idi-p/46670

Would be a great addition to the roadmap!

[damien.bouquier]

@Axel_H 

Yes, sorry for the repost, it's exactly the same idea 🙂

[Axel_H]

@damien.bouquier great minds think alike ! 😄

[Anilkumarch]

Great Idea....it helps to get rid of creating duplicate line items in use cases like where we need to override the caluclated value.

[tabendroth]

The possibilities this would introduce to modelling would be mindblowing and I can think of a thing or two (workarounds) in nearly every model I ever built which could be replaced. 

[thutten]

I support this idea whole hartedly. 

Can come with a few models where it would have saved quite some cells and improved User Experience

[rolympia]

I like this idea.

One case this applies to is the override functionality for numeric data, which currently involves 1) an override? boolean that users will check and 2) the override value. The boolean is still present, but it moves to the back-end, possibly with less dimensionality. And I don't want us to underestimate the user experience. The very fact that a user clicks on the cell is enough to show intent to want to override. No need to separately tick a boolean AND input an override number.

And this is just one case. There are many many others.

[Sukh_Sandhu]

This would be very helpful.