Is DCA the right way to solve this?


Is DCA the right way to solve this?

I have module where I need to make the line item formula dependent on user defined criteria. For example, the user selects the material they wish to be use as part of a price quote and the formula for the line item cost calculation changes based on that material, as different materials have different yields.  Should I use Dynamic Cell Access or is there a better way to do this?


Re: Is DCA the right way to solve this?

DCA is about security; I'm not clear how what you are describing requires security. This sounds more like a list of materials in a dropdown list that affects the numerical results of a line item formula.
Chris Schulze
Solution Architect

Re: Is DCA the right way to solve this?



This isn't DCA, but would something like this work for you?


I have a module of Products and the amounts:2019-03-07_18-14-24.png


I have another module, defined by Users as well as Products:


I have third module, which will some the data from what has been selected from the previous picture:


Place them on a dashboard:2019-03-07_18-18-15.png

Different Products selected:




Is this what you are looking for?



Master Anaplanner/Community Boss

Re: Is DCA the right way to solve this?

As @schulze said, DCA is all about read / write / invisible access, and is not related to calculations

On a wider context of "different calculation for different elements (e.g. products), we often see multiple level IFs as and SELECTs as users change the logic for different list elements.

This is not a good appraoch as multiple level IFs are not good for performance.  One should look at what actually changes for each element and model those using LOOKUPs and mapping modules.

In extreme cases where there is a complex formula, a good appraoch is the calculate the different variables for all products and then use a line item subset to pull those into the target module, again using a LOOKUP module. This is especially good when the usersd are able to choose the calculation method they want

Hope this helps





Re: Is DCA the right way to solve this?

I think you should go with Dependent drop down list concept instead of DCA.DCA is more on particular cell access.