What are Parameters?
Parameters are custom variables that you can add to your projects, allowing you to use them in multiple models and change multiple assumptions at once. Parameters are only usable in Model custom formulas.
Parameters are managed by clicking the button at the top of a Table page.
Clicking this button will open a Modal where you can manage the Parameters for the current Project. From here we can create, update and delete Project Parameters.
To create a new Parameter, click the
+ button in the upper right of the
Parameter Modal. This will add a blank row below your existing Parameters. Enter a new name and value, then click the Save button.
At this point your new Parameter will be usable in Model formulas.
Updating a Parameter Value
From the Parameter Modal, simply change the name or value for an existing parameter and click the
Save button. Doing so will update the Parameter's value in all the formulas it is being used within.
Once you have added parameters, you can use them from any Model created using a
custom formula. When creating your model, you can insert parameters within the formula by manually typing
param(name) in the formula field or by clicking a parameter on the list below the formula.
From the Parameter Modal, if you hover over an existing Parameter row, a
Delete icon will become visible. Clicking this icon will remove the Parameter from the current Project.
You are not able to delete Parameters that are in use. If you do so, we will warn you and show which row model formulas that are using the Parameter. Once there are no formulas referencing a Parameter, you will be able to remove it.