Skip to main content

Custom Fields: How to use a Numeric Calculation field

Learn how to create numeric calculation fields to automatically compute values - such as risk scores or asset sensitivity - using mathematical formulas.

Overview

Numeric calculated fields allow you to perform automated calculations using numeric inputs or numeric values assigned to single or multiple select fields.

Common Use Case

Calculate an asset's total Sensitivity Score by averaging the individual numerical values of its Availability, Confidentiality, and Integrity fields.

How to Set Up a Numeric Calculation Field

  • Step 1: Navigate to Assets inside of Settings

    • Go to Settings > Resources > Assets

    • Go to the Custom Fields section and click on "+"to add a new field.

  • Step 2: Create Input Fields with Numeric Values

    • Create a Single or Multiple Select field and name it (e.g., Availability).

    • Add your drop-down options: 'Low', 'Moderate', 'High', 'Very High'

    • Click on Configure extra properties and toggle on Enable numeric value. Click on Done.

    • Open Show extra properties for each option and assign a numeric value (e.g., Low = 1, Moderate = 2, High = 3, Very High = 4)

    • When you are done, click on Done to save.

    • Repeat this process for any additional input fields (e.g., Confidentiality and Integrity).

  • Step 3: Configure the Numeric Calculation Field

    • Click on "+" to add a new custom field and and select Numeric Calculation.

    • In Title, enter the name of the field.

    • In the formula editor, enter your calculation using your input fields, numbers, conditionals ((IF)), functions ((MIN), (MAX), (AVG), or (SUM)) or standard arithmetic operators ("+", "-", "*", "/").

      • Example: You can use the average function to calculate the asset's sensitivity based on the three inputs you have just created to calculate the average of all three. In this case, the formula would then be: AVG(Availability,Confidentiality,Integrity)

    • Set your score ranges.

    • Click Done to save.

Calculations Across Connected Elements

You can also pull numeric data from connected or linked items to perform cross-element calculations.

  1. Navigate to the resource or module where you want the final calculation to appear.

  2. Click + and select Numeric Calculation.

  3. In the formula builder, open the field dropdown menu and select the target Connected Resource.

  4. Choose the specific custom field from that connected resource that you wish to include in your formula.

  5. Enter any relevant functions or arithmetic expressions and click Done.

Did this answer your question?