Calculate Rating based on other ratings

[Theja Yamjala]

Hi,

I have a requirement that, I have a table "assessment" in this form, I have child fields(tabs in the same form) that has ratings,

ex: con.rating field has  (1 - High Risk - VAlue(1)
2 - Moderately High Risk(2)
3 - Medium Risk(3)
4 - Moderately Low Risk(4)
5 - Low Risk),

for  project has (1 - High Risk Value(1_hr)
2 - Moderately High Risk(2_mhr)
3 - Medium Risk(3_mr)
4 - Moderately Low Risk(4_mlr)
5 - Low Risk(5_lr))

Similar to this I have another 3 rating fields.

I want to take the avg of all the field rating and populate it in another rating field.

Thanks

[Sandeep Rajput · Accepted solution]

@Theja Yamjala You can choose to calculate the average rating either using a script or using decision builder. Please refer to https://docs.servicenow.com/bundle/utah-application-development/page/administer/decision-table/conce... to know more about Decision Builder.