Use a Parameter in a Workbook Calculation

Use a parameter to replace a constant in a calculation that you create in the workbook's My Calculations folder.

This tutorial provides a use case explaining how to use a parameter in a workbook calculation:

Tutorial icon Tutorial

  1. On the Home page, select a workbook, click Actions, and then select Open.
  2. In the Data Panel click Data.
  3. Locate the My Calculations folder, right-click it, and select Create Calculation.
  4. In New Calculation, enter a name for the calculation.
  5. In the calculation field, use this syntax to build the calculation:
    @parameter("parameter name")('default value')
    For example:
    @parameter("Dimensions")('Order Priority')
  6. Click Validate to validate the calculation, and then click Save to save the calculation.
  7. Click Save to save the workbook.