Drilldown highlights relevant logic string

Drilldown highlights relevant logic string

When a user uses the drilldown feature it would be awesome if the platform highlighted the particular logic string that was being applied within the formula to determine the final result. This would be helpful to parse long, complex formulas with many possible results. For instance, sometimes formulas have many IF a THEN b ELSE 0 statements, but it is difficult to determine which of the "...ELSE 0" clauses is the one being applied. This would help end-users better understand the formula text and also help model builders troubleshoot formulas that are not producing the desired result.

9 Comments
Miran
Community Manager
 
Status changed to: Your support is needed
Rebecca
Valued Contributor
 
Status changed to: Under Investigation
CommunityMember115881
Certified Master Anaplanner

Hi,

 

It would be super handy if the platform could highlight (underlined, bold,...) the logical path taken in a formula when drilling-down on a particular cell.

Sometimes, with complex IF statements, it can be quite time-consuming to try to work out which branch of a formula the system is using. Highlighting it would save many people a considerable amount of time (developers as well as users).

 

Regards,

 

Douglas

Miran
Community Manager
 
Status changed to: Your support is needed
chad.seddon
Occasional Contributor

I think it would be cool if when a multi-clause formula is being used in Anaplan, the clause in the formula that is being calculated is highlighted or called out in some form when using F8 or Drill down.

 

this would enable a builder/admin to easily identify how a calculation function is being recognized. 

Miran
Community Manager
 
Status changed to: Your support is needed
CallumW
Certified Master Anaplanner

Love the suggestion and this has already been posted on the following link;

 

https://community.anaplan.com/t5/Idea-Exchange/Highlight-the-logical-path-taken-in-a-drill-down/idi-... 

 

@Mirancould we merge these requests?

Gwen.pryor
Regular Contributor
 
Status changed to: Under Investigation
mtlumanog
Certified Master Anaplanner

this will be very helpful