Functions

On this page:

• Functions Properties

• Use a Global Variable or Global Selection Page Variable

• Update the Value of the Global Selection Page Variable

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:

Function	Description
=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 Selection Page parameter.

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

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.

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.

Property	Description
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 ##). For examples of selection pages, refer to Workbook Selection Page Example.
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 off the selected Selection for the On Open in the Workbook Properties page.
Cancel	Close the Functions window. (Note: The workbook will not save new changes automatically.)
Save	Inserts your global variable or global selection page parameter. Once inserted, the variable can be used in a formula if its cell is referenced.

Use a Global Variable or Global Selection Page Variable

To insert a global variable or a 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.

Refer to the Functions Properties section above for more details on the Functions window.

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.