How to calculate the sum of all records amount variable in a Multi Row Variable Set

[tanuja_g]

In a MRVS, I have one variable called amount. Have to calculate the sum of all the records amount. If amount is lesser than or is 100.00 it should display approval1 variable so that user can select approver. If the amount is greator than 100.00 it should display approval2 variable. 

Any solutions should be helpful.

Thanks in advance.

[dgarad]

Hi @tanuja_g 

Please refer below link.

https://www.servicenow.com/community/itsm-forum/populate-field-outside-mrvs-with-a-total-sum-of-fiel...

[tanuja_g]

Hi dgarad,

Thank you so much, that post helps me alot.

But When we delete or remove any of the records in MVRS - The amount variable remains same with the total value of intial records. The amount is not getting changed(Not subtracting the specific value of deleted records)

How to overcome this drawback?

[dgarad · Accepted solution]

refer the below link.

https://www.servicenow.com/community/developer-forum/how-to-calculate-the-total-of-variables-into-an...

https://www.servicenow.com/community/developer-forum/mrvs-detect-when-a-row-is-removed-or-deleted/m-...