Dynamic Cells Calculation (DCC)

Dynamic Cells Calculation (DCC)

 

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.

 

 

9 Comments
Occasional Contributor

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

Certified Master Anaplanner

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!

Certified Master Anaplanner

@Axel_H 

 

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

Certified Master Anaplanner

@damien.bouquier great minds think alike ! 😄

 

Certified Master Anaplanner

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

Contributor

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. 

Occasional Contributor

I support this idea whole hartedly. 

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

Certified Master Anaplanner

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.

Contributor

This would be very helpful.

Users Online
Currently online: 70 members 378 guests
Please welcome our newest community members: