Editing what is visible when drilling down a calculation

ChrisAHeathcote
Community Boss

Editing what is visible when drilling down a calculation

Is it possible to edit what can be seen when a user drills down on a cell?

The model has a few complex formulas and the user does not need to seem them but would like to retain the ability to drill down through the different levels of the calculation.

Thanks,

Chris Heathcote

Chris
HeathcoteAndHerran.com
4 REPLIES 4
rob_marshall
Moderator

@ChrisAHeathcote 

 

I don't believe so, but possibly create a dummy line item that is just the result of the logic and base the downstream calcs off the dummy?

 

Rob

ChrisAHeathcote
Community Boss

@rob_marshall 

Interesting idea but the module contains many line items which would need similar treatment. 

The value does not exceed the cost and effort to build.

Appreciate the quick response.

Chris 

Chris
HeathcoteAndHerran.com
rob_marshall
Moderator

@ChrisAHeathcote 

 

Yep, agreed.  It is a possible solution, just not a good one if there are many line items with logic you want to "hide".  Another possible solution, and it is in line with the previous one, but to have a "reporting" module where the line items are just "dummies".  Think of the logic as a CALC module and then you have the reporting module just referencing the calc.  Might be too much of a hassle, though.

 

Rob

ChrisAHeathcote
Community Boss

@rob_marshall 

An idea I can use in future projects but for now it is not a burning priority of the client.

Chris
HeathcoteAndHerran.com