Formula Drill Down

The Nectari Excel Add-in enables you to get details about an amount calculated through a Nectari formula. This allows the user to do deeper analysis by seeing what the Nectari formula result is actually consists of in terms of raw data.

Example

Here is an illustration of the report with Nectari Formulas generated from the General Ledger (GL) entries that contribute to the total Debit Amount of a GL Account.

To drill down on the selected amount:

  1. Either right-click the cell containing the amount and choose Formula Drill Down in the menu, OR

    While the cell is selected, click Formula Drill Down in the Add-ins tab.  

  2. Choose if All fields should be brought back or Specific fields.

  3. For specific fields, the following screen will appear to select and place the columns in a particular order.

    Tip

    Select the Default Drill Down option to access the formula details directly, without getting a pop-up window.

    If it has been set up for formulas, the Formula Drill Down as well as the Default Drill Down features will automatically use the Reporting Tree as a filter and show it in the filter list.

  4. Click OK. The result of the drill-down is shown in a separate sheet of the Excel workbook.