How do I change the risk rating calculation logic in the Company record?

ChuanYanF
Tera Guru

‎07-21-2025 06:47 PM

Dear experts,

 

I would like to know how to change the scoring logic for the risk rating in the company record form, currently there are 4 assessment rating that will compute the overall risk rating for the company, I would like to remove two of it and change the scoring logic of it. Where should I go and how should I implement the changes?

 

ChuanYanF_0-1753148727912.png

 

0 Helpfuls
  • 312 Views
1 REPLY 1

anshul_goyal
Kilo Sage

‎07-21-2025 10:38 PM

Hello @ChuanYanF,

To change the scoring logic for the risk rating in the Company record form in ServiceNow, you'll need to modify the logic behind the scoring and potentially update any Business Rules, Script Includes, or Calculated Fields that compute the overall risk rating.

Here’s a step-by-step guide tailored for a typical implementation:

Step 1: Identify Where the Risk Rating Is Computed

  1. Go to the Company table:

    • Navigate to System Definition > Tables.

    • Search for and open the Core Company table (usually core_company).

  2. Look for the Risk Rating field:

    • In the list of fields, find the one related to "Risk Rating" or similar (it might be a calculated field or manually set via script).

    • Check the field type. If it's calculated, there will be a script in the Calculated Value.

  3. Check for Business Rules or Script Includes:

    • Go to System Definition > Business Rules.

    • Filter by Table = core_company.

    • Look for any rule with names like "Calculate Risk", "Set Risk Rating", etc.

Step 2: Modify the Scoring Logic

  1. If it's a Calculated Field:

    • Open the Risk Rating field.

    • Modify the Calculated Value script.

    • Remove references to the 2 assessment ratings you no longer want.

    • Adjust the formula to compute based on only the 2 remaining ones.

    Example:

     
// Previous logic with 4 assessments
var score = (assessment1 + assessment2 + assessment3 + assessment4) / 4;

// Updated logic with 2 assessments
var score = (assessment1 + assessment2) / 2;

answer = getRiskLevel(score);

  • If logic is in a Business Rule:

    • Open the Business Rule.

    • Update the script in the Script section to reflect the new logic.

    • Be sure to remove or comment out logic involving the removed assessment scores.

  • If logic is in a Script Include:

    • Go to System Definition > Script Includes.

    • Search for any Script Include that might compute or assist in calculating risk.

    • Modify it accordingly and ensure it's called properly.

Step 3: Remove the Two Unwanted Assessments

  1. Check if assessments are records or fields:

    • If they are assessment records (e.g. from Performance Analytics or Assessments), go to Assessments > Assessments.

    • Retire or deactivate the ones you no longer need.

  2. If they are fields on the Company table:

    • Consider whether you want to delete or just hide them.

    • You can hide them via form layout or UI Policies.

Please mark my solution Accepted and Helpful for future references.

Thanks

0 Helpfuls