Configuration of calculations for Risk Event

bartykowalsky
Tera Contributor

Hello Community,

 

Is there possible to configure the way that the values from Summary tab in Risk Event (sn_risk_advanced_event) are calculated? (Indirect amount, Rapid recovery amount, Recovered amount etc.) 

I was looking for any configuration in System Definition -> Tables. I investigated all of the fields I am interested to change calculation, but I couldn't find it.

I attached the screenshot. 

bartykowalsky_0-1712672228582.png

 

 

1 ACCEPTED SOLUTION

jaikishan1
ServiceNow Employee
ServiceNow Employee

Hi,

You can provide a custom script for the fields to calculate the value. To achieve this, you can follow the below steps:
1. Open the dictionary field.
2. Go to "advanced view" under related links for the dictionary field.
3. Check the "calculated" check box under the "calculated value".
4. Provide the script.

Regards,

Please mark this as helpful if it solves your query.

Regards,
Jai

View solution in original post

3 REPLIES 3

jaikishan1
ServiceNow Employee
ServiceNow Employee

Hi,

You can provide a custom script for the fields to calculate the value. To achieve this, you can follow the below steps:
1. Open the dictionary field.
2. Go to "advanced view" under related links for the dictionary field.
3. Check the "calculated" check box under the "calculated value".
4. Provide the script.

Regards,

Please mark this as helpful if it solves your query.

Regards,
Jai

Hello, 

Thanks, that is very usefull 🙂

Do you have idea how should a script look like if I want to implement for example this:

Indirect amount = Gross loss - Net loss

 

Thanks in advance

Hi @bartykowalsky ,

The current object would have the information about the risk event records. It can used to get the values of different fields using the column names and use them like:
return current.gross_loss - current.net_loss.

If this solves your query, please mark the response as helpful.

 

Regards,

Please mark this as helpful if it solves your query.

Regards,
Jai