Skip to main content

Formula Drill Down

The Formula Drill Down feature lets you explore the underlying records that contribute to a value returned by a NecAccess formula. This provides deeper insight into how a result is calculated and which source entries are included.

When to use the Formula Drill Down​

  • Investigating the data behind a result: View the detailed records that make up a formula’s output.
  • Understanding which source entries are included: Trace which ERP or data‑model records contribute to the calculation.
  • Auditing or validating amounts: Confirm values 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. Click Ok. A new worksheet is created with the drill-down results.
note

If the formula uses a Reporting Tree node, it is automatically applied as a filter.

Default Drill Down​

The Default Drill Down option lets you skip the field‑selection dialog when drilling down into a formula. Once enabled, the add‑in automatically reuses your last drill‑down configuration (or all fields, if that was your previous choice).

This is especially useful when you frequently drill down using the same set of fields and want to streamline the process without reconfiguring the options each time.

You can enable or disable this option directly in the Drill Down dialog before confirming the action.

Example - Retrieve Ledger Posting documents​

Use this drill‑down to identify the exact documents contributing to a Ledger Posting total. This helps you verify the source entries behind the amount and understand how the total was calculated.

  1. Select the cell containing the NecAccess formula result you want to analyze.
  2. In the Add‑ins tab, select Formula Drill Down.
  3. Choose Specific fields to control which columns appear in the drill‑down results.
  4. From the list, select Document Number, Document Description and Ledger Posting.
  5. Click Ok. A new sheet is created showing each document that contributes to the Ledger Posting total, allowing you to validate and trace the underlying entries.

If a field is configured with a hyperlink format in the data model, its values appear as clickable links in the drill‑down results. This allows you to open related documents or external resources directly from the generated sheet.

Hyperlinks are recognized only when a field value begins with http:// or https://. Selecting a link opens the target address in your default browser. Other hyperlink formats—such as Markdown, HTML tags, or custom link syntax—are not supported.