Skip to main content

Formula Drill Down

A NecAccess formula returns a single calculated value, such as a total sales figure or a budget amount. Formula Drill Down shows you what is behind that number. It breaks the result down into the individual records that were added together to produce it, and writes them to a new sheet with the fields you choose.

For example, if a formula returns total sales for a region, the drill down lists every transaction included in that total: document numbers, dates, amounts, and any other fields available in the data model. This makes it straightforward to verify a number, spot an unexpected entry, or trace a discrepancy back to its source.

If the formula references a Reporting Tree node, it is applied as a filter on the results automatically.

Excel Add-in Formula Drill Down

When to drill down into a formula​

  • Investigate the records behind a result to see which source entries make up a formula's output.
  • Trace ERP or data model entries that contribute to a specific calculation.
  • Audit or validate amounts without manually exporting or filtering source data.

Drill down into a formula​

  1. Select a cell that contains a NecAccess formula result.
  2. Do one of the following:
    • Right-click the cell and select Formula Drill Down, or
    • In the Add-ins tab, select Formula Drill Down.
  3. Choose the fields to include:
    • Select All fields, or
    • Select Specific fields to choose and reorder them.
  4. (Optional) Select Default Drill Down to skip this dialog in future drill-downs.
  5. Select Ok. A new worksheet is created with the drill-down results.
ExampleRetrieve Ledger Posting Documents#
Scenario

You want to identify the exact documents contributing to a Ledger Posting total and verify the source entries behind the amount.

Details
  1. Select the cell containing the NecAccess formula result you want to analyze.
  2. In the Add-ins tab, select Formula Drill Down.
  3. Select Specific fields to control which columns appear in the results.
  4. From the list, select Document Number, Document Description, and Ledger Posting.
  5. Select Ok. A new sheet is created showing each document that contributes to the total.
Keep in mind

Only fields included in your Selected Fields list appear in the results. If a field is missing from the output, check that it was added before confirming.

Default Drill Down​

When Default Drill Down is enabled, the add-in skips the field selection dialog and reuses your last drill-down configuration automatically. If no previous configuration exists, it defaults to all fields.

Enable or disable this option directly in the Drill Down dialog before confirming.

If a field is configured with a hyperlink format in the data model, its values appear as clickable links in the drill-down results. Selecting a link opens the target address in your default browser.

Hyperlinks are recognized only when a field value starts with http:// or https://. Other formats such as Markdown, HTML tags, or custom link syntax are not supported.