How to calculate the sum of 2 fields and add into another

VIKAS MISHRA
Tera Contributor

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.

 

 

 

 

 

VIKASMISHRA_1-1734355488990.png

 

7 REPLIES 7

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".

Ankur Bawiskar
Tera Patron
Tera Patron

@VIKAS MISHRA 

what's your business requirement here?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

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.