Skip to main content

Functions

Using the Functions window, you can reference a global variable or global selection page in your workbook or workbook selection page. When a selection is made, it will generate one of the following functions:

FunctionDescription
=NECGLOBALVARIABLE("@@variableKey")Function that is created within the selected cell when the user selects a Global Variable.
=NECSELECTIONPAGEVALUE("##parameter")Function that is created within the selected cell when the user selects a Global Variable.

By using these functions, users can keep the value dynamic. To access the Functions window, go to the toolbar and click Analysis > Functions.

Benefits​

Why use Functions?

  • Efficiency: Parameters can be set through a Selection page pop-up for clearer control. Additionally, you can use Global Variables to apply consistent filters across reports, enhancing accuracy and coherence.
  • Automated Data Refresh: Set up automated refreshes for workbook data, ensuring reports are always up-to-date with the latest information.
  • Improved Decision Making: Use functions to create interactive and responsive reports that help in making informed business decisions quickly.

Use a Global Variable or Global Selection Page Variable​

To insert a global variable or global selection page variable:

  1. From the Analysis tab, select Functions.

  2. Select a variable from the Global Variable or Selection Page Parameters list.

  3. Click Save. That variable can be used in a formula if its cell is referenced.

Update the Value of a Global Selection Page Variable​

To update an existing Selection Page Parameter:

  1. From the Settings menu on the right, click on Selection Page.

  2. From the Selection Page window, change the value set.

  3. Click on Confirm to save and apply your changes.

Functions Properties​

The Functions window allows you to pick from a Function Category section and a List section. You can also cancel or save your selection.

PropertyDescription
Function Category

Choose between two function categories: Global Variable and Selection Page Parameters.

  • Global variables use @@ in front of the parameter.
  • Selection pages use ## in front of the parameter.
  • Reports can use both types of parameters (@@ and ##).
List

Select the variables or parameters to add. You can select them from the drop-down or type them in for a quicker selection. The values displayed for the selection page parameters will be based on the selected Selection for the On Open in the Workbook Properties page.

Cancel

Inserts your global variable or global selection page parameter. Once inserted, the variable can be used in a formula if its cell is referenced.