Constants

Simply put, Constants are the numbers and dates used in a metric’s formula. These are typically auto-generated when using the “Add Segment” feature but there are many other uses for Constants throughout your model.

Main Constants and Segment Constants appear underneath a metric’s formula bar. These are dates and numbers that are used specifically in either the main formula or in a specific segment. If you would like to add additional Constants just look for the plus button in either the Main Constants or Segment Constants section.

Scenario Constants are located in the sidebar of your model. These Constants can be referenced by any row in the model, such as in the above example where a row’s start date and salary increases are being driven by two Scenario Constants. If you would like to add additional Scenario Constants you can hit the “Add Constant” button in that section.

Once you have created the Constants that you would like to use you can search for those constants by name in the formula bar, as is shown in the above example. You can also select any relevant dates for a row/segment and reference a Constant.

As you may have noticed, each Constant in a model can be clicked into to change its date or value.