Local action variables

Local action variables are defined in actions and exist only during an action's execution. If an action requires multiple calculations during its execution, local action variables can be used to hold an intermediate results and values. Use local action variables as an alternative to creating report variables that exist permanently but whose only purpose is to assist in calculating an action.

You create local action variables in the Define Action dialog box when you define actions in the spreadsheet, formula function global actions, or report actions. In the Parameters field of the action, select Actions > New Variable. Specify a name for the variable.

If you create a formula function global action and specify one or more formula arguments, a local action variable is created for each argument.

The value of one local action variable can be used in the formula of another. If an action references multiple local action variables, the order in which they are listed in the the Define Action dialog box is important. Ensure that variables are not referenced in formulas before they are listed.