Create a Parameter

Create a parameter to store and manage a current value or values that you want to use in multiple places in a workbook.

For information about how to choose the parameter's properties, see About Parameter Properties.
  1. On the Home page, select the workbook to add a parameter to, click the Actions menu, and then select Open.
  2. In the Data Panel click Parameters.
  3. In the Parameters Pane, click Add.
  4. In the Name field, enter a unique name.
  5. Click Data Type and choose the type of data you want the parameter to accept.
  6. In the Possible Value Type field select how you want the user to enter the parameter's value.
  7. In the Initial Value field, select Value if you want to enter the parameter's initial value, or select Logical SQL Query if you want to provide a SQL query to determine the initial value.
  8. Click OK.
  9. Click Save.