Dynamic Cells Calculation (DCC)

Options
damien.bouquier
damien.bouquier Member, ALL USERS, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner
in Planning & Modeling

 

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.

 

 

Tagged:

Comments

  • Farooqkamal1
    Farooqkamal1 Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 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. 

  • Axel_H
    Axel_H Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Contributor

    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
    damien.bouquier Member, ALL USERS, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    @Axel_H 

     

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

  • Axel_H
    Axel_H Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Contributor

    @damien.bouquier great minds think alike ! 😄

     

  • tabendroth
    tabendroth Member, ALL USERS, Employee, Certified Model Builder Posts: 5 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. 

  • mtlumanog
    mtlumanog Member, ALL USERS, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    Great idea. This will be more flexible than the formula scope feature.

  • pintusharma
    pintusharma Member, ALL USERS, Certified Model Builder Posts: 2 New Contributor

    Much needed step to get rid of addtional line items.

  • michael.jones
    michael.jones Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Yes, would be very useful. This does exist in a rival product with the STET function.   Eg IF something THEN calculate something ELSE STET.  Where STET allows the cell to receive a manaul entry.

  • Needanswers
    Needanswers Member, ALL USERS Posts: 3 Occasional Contributor

    pls implement this 😭

Categories