How to calculate the sum of 2 fields and add into another
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2024 05:30 AM
People can add multiple incident records to the PRB record as mentioned in the below screenshot.
So the requirement is whenever the new incident is added to the PRB then system should auto calculate the total value of column "field 1" and populate in column "Total"
For eg. in the below screenshot the value in first record of column "total" should be 1 and in the second record the value in "total" should be 7 as its doing sum of 1 and 6. and it should keep doing the same with the new records added below in this PRB.
Please suggest.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2024 05:56 AM
If you do the following, it will show the total at the bottom of the view. I think that would be more valuable than trying to set a field in each incident with a running total.
From the related list on the column you want to sum, right click and select Configure -> List Calculations. Select "Total Value".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2024 05:44 AM
what's your business requirement here?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2024 06:30 AM
HI Ankur,
In my Actual requirement the parent record is the Project and is having multiple child records with the columns to calculate the COST, and there is no way to change the requirment and now we have to achive it as it is , how i explained in the above description.
The example i have given in my PDI with the help of incident and problem record so that it would be easy to make you all understand it.
Please let me know that is it possible to print the total of field 1 to column "total".
You can see my first explanation of this requirement on the top to understand it.