Skip to main content

Functions

The Functions feature lets you reference a global variable or global selection page in your workbook or workbook selection page. This keeps values dynamic and ensure consistent filtering across reports.

To open the Functions dialog, go to the ribbon and select the Analysis tab, then Functions.

When to use functions​

  • Increasing efficiency: Use a Selection page to manage parameters clearly, or apply global variables for consistent filtering.
  • Automating data refresh: Ensure reports always reflect the latest information.
  • Improving decision making: Build interactive and dynamic reports that help guide business decisions.

Types of functions​

You can insert one of the following types of functions:

FunctionDescription
=NECGLOBALVARIABLE("@@variableKey")Inserts a Global Variable into a selected cell.
=NECSELECTIONPAGEVALUE("##parameter")Inserts a Selection Page parameter into a selected cell.

Insert a variable or parameter​

To insert a global variable or global selection page variable:

  1. On the Analysis tab, select Functions.
  2. Choose a variable from either the Global Variable or Selection Page Parameters list.
  3. Click Save. You can now reference the cell in a formula.

Update a global selection page variable​

To update an existing selection page parameter:

  1. On the Toolbar panel, select Selection Page.
  2. In the Selection Page dialog, update the desired value.
  3. Click Confirm to apply the changes.

Function properties​

The Functions dialog includes two sections—Function Category and List—used to select a global variable or a selection page parameter.

PropertyDescription
Function CategorySelect either Global Variable or Selection Page Parameters.

  • Global variables are prefixed with @@.
  • Selection page parameters are prefixed with ##.
  • Reports can use both types.
ListSelect a variable or parameter from the list or type to search. The available selection page parameters depend on the selected Selection Page in On Open.
XClose the dialog without applying changes.
SaveInsert the selected global variable or selection page parameter. Use the inserted variable in a formula by referencing its cell.