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

See Syntax for Referencing Parameters.

1. On the Home page, hover over a workbook, click Actions, 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.