Applies to:

• Velixo NX
• Velixo Classic
• Acumatica, Cegid XRP Flex, MYOB Advanced

TABLE OF CONTENTS

• Overview

• The Drilldown worksheet
• Tips
• Limitations

Overview

A Velixo Drilldown feature presents a summary of underlying data that corresponds to a cell containing a Velixo function.

A simple example will demonstrate how easy it is to create a drilldown.

Let's consider a chart of accounts which lists the ending balance for each account. In this list, we locate the Sales Revenue account and click on the Ending Balance cell (see the figure below).

In this example, the values being displayed are computed using the ACCOUNTENDINGBALANCE function.

To get a drill-down for this number, we would click the Drilldown button on the Velixo ribbon.

This opens a new worksheet tab which displays summary information for sales revenue corresponding to the specifications of the account ending balance function.

The Drilldown worksheet

In a Drilldown worksheet, we can quickly navigate to the reference data:

• We can click any of the links in the Source Cell column to return to the original Velixo function.

• We can click any of the links in the Transactions column to open the corresponding generic inquiry results within your ERP:
  
  

  

Tips

These tips will help us get more out of the drill-down feature:

• Before drilling down, it is recommended that we Refresh our results. Even when a cell may display an outdated value from a prior refresh, the drill-down will always contain the latest information from your ERP.

• Drilling down can also be performed on certain Excel summarizing functions (e.g., SUM & AVERAGE).

• To improve performance, we'll want to minimize the number of cells that we include in our drill-down.

Limitations

• If we are using SUMIF, VLOOKUP, HLOOKUP, MATCH, or the INDEX function, the drill-down won't work. This is because it cannot identify all of the cells that were included. Since Excel applies formula auditing, it includes the entire source range in such functions, and the drill-down feature cannot display the complicated results.

• Complex math operations cannot be represented, since a drill-down merely presents a summary of all the relevant accounts.