Configure your user preferences.
| Option | Description |
|---|---|
| Show disabled | Include disabled segment values when discovering, expanding or exploding and in lists. |
| Show secured | Include secured segment values when discovering, expanding or exploding and in lists. |
| Treat end dated segments as disabled | If a segment value has a "From" or "To" date specified which falls outside the current date then treat it the same as a disabled segment value. |
| Show segment criteria errors | If you enter segment criteria which does not exist in the list of segment values, the GL Wand function will return an error message. If you would prefer that the function returns an empty string (or zero balance when applicable) then disable this option. |
Hierarchy level spans columns | When populating expand hierarchy results, span the hierarchy levels across columns. |
Calculation drills to new workbook | When enabled, drilling down from a function (calculation) will populate the results into a new workbook. |
Drilldown drills to new workbook | When enabled, drilling down from a previous drilldown report will populate the results into a new workbook. |
Double click enabled | When disabled, a double click in Excel will no longer open lists of values and execute drilldowns. |
Add a dummy line for unsupported drilldowns | Adds a dummy line to a drilldown where the source line was not supported. |
Suppress zeros on drilldown | Exclude items in the balance drilldown report if the opening balance, dr movement, cr movement and closing balance are all zero. |
| In-Memory Options Enable | Enable or disable the in memory database option. |
| Maximum Age | Items from the In-Memory database that have not been accessed for the specified number of days will be discarded. |
In-Memory Clear | Clear the In-Memory database. You must unlock the option by clicking the lock first. |
Show last calculated value | Show the last calculated value, if available, when the calculation mode is set to off. See Calculating for more detail on this option. |
