Using Explorer Pro Formula Debug

Using Debug (Alt-D) you can use the right and left arrow keys on the keyboard to see the effect of replacing parts of the formula with their values.

The right arrow key steps forward through the debug sequence.

The left arrow key steps backwards through the debug sequence.

With Explorer Pro Debug you get two views of the formula:

An indented view that optimises for viewing the overall formula as it is debugged.

An Expression view that allows you to explore any of the expressions in detail, including expressions that have already been replaced in the Indented Formula view.

Step 1

->Click the right arrow key on the keyboard ->Step 2:

Because $B$2 is a position argument for OFFSET it makes no sense to replace its address with a value.
So Debug selects the next expression to resolve (Filing_Choice):

->Click the right arrow key on the keyboard ->->Step 3.
Filing_Choice is replaced with its value in the indented formula, but the expression box still shows the full formula.

->Step 4:
All the arguments for OFFSET have been resolved so OFFSET is the next expression to be resolved:

->Step 5:
Because OFFSET resolves to an array it gets replaced by its expression number {~2} and the filtered result array values are shown in the results box to the right. This avoids cluttering the formula with large numbers of array values. 

The results box shows the row number for each result, and the results can be filtered to avoid showing large numbers of empty, zero cells etc.

->Step 6:

Now two expressions have been replaced by their expression numbers:

You can click-select any expression or expression number during Debug to see its Values in the Results Box.

This is the result of clicking the {~2}

Note:
Both Expression number 2 (OFFSET) and expression number 6 (Table2[Tax Rate]) are still substituted in the indented formula, but are shown in the expression boxes with their expression number label.

When you use the forward or back arrow keys the Debug process resumes at the next or previous debug step.

Copyright © 2020 Decision Models Ltd