How to calculate the sum of the value in multi row variable set?

[hongsok]

Hi,

I am using the MRVS and need to sum the value of the hard drive's size as shown in the pic.

I would appreciate if anyone can give me a clue.

[Mark Roethof]

Hi there,

Please mark this answer as correct if it solves your question. This will help others who are looking for a similar solution. Also marking this answer as correct takes the post of the unsolved list.
Thanks.

Kind regards,
Mark

---

LinkedIn

[Sidney Junior]

Greetings, I'm having the same problem, use this tutorial, but it's still not working, can someone help me?

The field that I am going to sum : total_qnt_price

sys_id: total_qnt_price >> eb9e71af07b5101074cef2508c1ed0be

and the result field name is : u_total

-------------------------------------------

----------------------------------------------------------

-------------------------------------------------------

Business Rules - Code:

(function executeRule(current, previous /*null when async*/) {

var grMRVSAnswer = new GlideRecord('sc_multi_row_question_answer');
grMRVSAnswer.addEncodedQuery('parent_id=' + current.getUniqueValue() + '^item_option_new=eb9e71af07b5101074cef2508c1ed0be');
grMRVSAnswer._query();

var totalInt = 0;
while(grMRVSAnswer._next()) {
gs.info('--> Value TEST MATERIALS' + totalInt.value);
if(grMRVSAnswer.value != '') {

var amountInt = grMRVSAnswer.value.replace(',', '.');

totalInt = parseFloat(totalInt) + parseFloat(amountInt);
}
}
gs.addInfoMessage('start must be before end');
current.variables.u_total = totalInt;
current.update();

})(current, previous);

[hongsok]

Hi Sidney, please check Update as well.