A Calculation Field uses mathematical formulas and expressions to calculate a number that is displayed to the user on the front-end. You have the option to also display this number with or as a label instead. For example: If you have a Risk Score Calculation Field with scores ranging from 1 to 25, you can create Label Ranges to display the risk score as High, Medium, or Low instead of just showing the numerical values.

You'll first have to create a Calculation Field. Refer to the Creating a Field and Creating Advanced Calculations article to learn more. Once you have the Field created, follow the steps below to configure your Calculation labels.

How to Configure Calculation Labels

1. Before you start the configuration, it is helpful to have a clear picture of the Label Ranges you'd like to create. For this tutorial, we'll assume that Risk Score is the Field that we are creating labels for. All values in this field will range from 1 to 25 and we'd like to categorize our Risk Scores into High, Medium, and Low. We'll use the following label ranges:

• Low is less than 5 (Low < 5)

• Medium is greater than or equal to 5 and less than 15 (5 ≤ Medium < 15)

• High is greater than or equal to 15 (High ≥ 15)

In Step 5 below, we'll go over a slight different variation of the above ranges and show you how it can also be configured.

2. Find the Calculation Field you want to edit and click on the pencil icon to open it. 3. A pop-up modal will appear. Select the Label Ranges tab and then click Enable Label Ranges. 4. You'll then see 2 default Label Ranges auto-populate below. From here you have 2 options on how to set your Label Ranges:

• Greater than or equal to number: For each Label Range, you set the lowest number of that range (the value that this range will be greater than or equal to)

• Less than or equal to number: For each Label Range, you set the highest number of that range (the value that this range will be less than or equal to)

You can easily toggle between the 2 options by using the Radio buttons at the bottom of the modal.

5. The difference between the 2 options is in the "equal to" operator. Using the example Risk Score labels above:

If you are using the "Greater than or equal to number" option, the range would be as follows:

• Low is less than 5 (Low < 5)

• Medium is greater than or equal to 5 and less than 15 (5 Medium < 15)

• High is greater than or equal to 15 (High 15)

Using these ranges, a Risk Score of 5 would be considered "Medium" and a Risk Score of 15 would be considered "High".

If you are using the "Less than or equal to number" option, the range would be as follows:

• Low is less than or equal to 5 (Low 5)

• Medium is greater than 5 and less than or equal to 15 (5 < Medium 15)

• High is greater than 15 (High > 15)

Notice that in this option, a Risk Score of 5 would be considered "Low" and a Risk Score of 15 would be considered "Medium" instead. When you are deciding between the 2 options, make sure to note the differences in the "equal to" operator and choose the appropriate one for your labels.

For "Greater than or equal to number" label ranges

6. Start by editing the text box of the 2 auto-populated labels to the labels that you want. 7. Click into the text box in the second Label Range and set the lowest number for this range. In other words, choose the number that this label will be greater than. For our example, 5 is the lowest number in the "Medium" Risk Score label.

Notice that the first Label Range is always locked and doesn't have a box for a numerical value. Whenever you choose the Greater than or equal to number option, the numerical value for this first label will automatically be less than the value you entered in the second text box. In this case, the "Low" label will display when the Risk Score is less than 5. 8. You can choose the color you want the label to be by clicking on the Color Box Icon. A color palette will appear, you can either choose a color from the selection displayed or enter a HEX code for a custom color. Select the appropriate color for the "Low" and "Medium" labels. 9. Click on the + icon below "Medium" to add another Label Range. A new label will appear below. 10. Add the appropriate text and numerical value for this label. For this example, we'll be using "High" and "15". Then select the color you want this label to be. "High" is the last value in our range, so any Risk Score greater than or equal to 15 will be marked as "High". 11. Once you've finalized the labels, click Done to save and close out of the pop-up modal.

For "Less than or equal to number" label ranges

12. Click the radio button to the left of "Less than or equal to number".

13. You'll then see 2 default Label Ranges auto-populate. Start by editing the first text box to "Low" and then enter the numerical value of 5. This means that any Risk Score less than or equal to 5 will be labeled as "Low".  Then change the color of this label by using the color palette or by entering a HEX code. 14. Next, click on the + icon below "Low" to add another Label Range.

15. Click into the new text box and type "Medium" to change this label. Then add the numerical value of 15. This means that any Risk Score less than or equal to 15 and greater than 5 will be labeled as "Medium". Change the color of this label, if needed. 16. Click into the last text box and type "High" to change this label. Notice that the last Label Range is always locked and doesn't have a box for a numerical value. Whenever you choose the Less than or equal to number option, the last label will always be locked and the numerical value will automatically be greater than the value you entered in the second text box. In this case, the "High" label will display when the Risk Score is greater than 15. 17. Once you've finalized the labels, click Done to save and close out of the pop-up modal.

Calculation Label Display Options

18. Once you are done with configuring the Calculation Field Labels, find the Field again on your form and toggle the Field settings panel open if it's not already. You can do this by clicking on the drop-down arrow next to the Field name. 19. Click into the first drop-down menu on the left and you'll see 3 display options appear in this panel. You can set the Field to either display only the value, only the label, or display both. Select one of the options and then click out of the settings panel.  Front-End Display

From the business user's perspective, the display options will show up as follows when they are working on a form:

Value and Label Value Only Label Only The correct label will display depending on the calculation formula and the Field input values that you are referencing in the formula. In the example above, the Inherent Likelihood and Inherent Impact categories are assigned a numerical value. The numerical values of these two Fields are multiplied together to produce the Risk Score. If you change either one of these values, the Risk Score value and label will change accordingly.

Related Articles