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.
Its not to track sequencing, its related to some contract records requirement but i just have created the same scenarios in my PDI with PRB and INC records to reflect it so that it would be easy to understand.
There are no 8 related records its just 2 records now, filed one can have any no. in it , its not like there is 6 which means there are 6 records.
For your undderstanding i have attached a new and acutall screenshot which is the requirement and both the fields are mentioned there.
There actual requirement is related to the sum of COST which includes to complete a project, so every new incident gets added with the extended cost so the last incident should populate with the total cost of all the previous record and populate in the last record.
Below is the screenshot of the actual record.
