Editing what is visible when drilling down a calculation

ChrisHeathcote
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 Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
4 REPLIES 4
rob_marshall
Moderator

Re: Editing what is visible when drilling down a calculation

@ChrisHeathcote 

 

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

ChrisHeathcote
Community Boss

Re: Editing what is visible when drilling down a calculation

@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 Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
rob_marshall
Moderator

Re: Editing what is visible when drilling down a calculation

@ChrisHeathcote 

 

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

ChrisHeathcote
Community Boss

Re: Editing what is visible when drilling down a calculation

@rob_marshall 

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

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA