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]

Hmmm looking at the query closer:

grMRVSAnswer.addSizeQuery

It says addSizeQuery? This should be either addQuery or addEncodedQuery. In this case, addEncodedQuery.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn

[hongsok]

Hi Mark,

It turn out the result is 0.

[Mark Roethof]

One moment, I'm simulating now on my PDI 🙂

Did saw already that the:

 + parseFloat(amountInt);

Is not oke anymore, because amountInt is commented.

[Mark Roethof]

Just tried below code, works instantly. Obviously check the sys_id and field names used.

I had to modify slightly because my example code was about multiple MRVS + value with decimals.

(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=bc6fb0f2dbbb7f40b9f39026db9619af');
	grMRVSAnswer._query();

	var totalInt = 0;	
	while(grMRVSAnswer._next()) {
		if(grMRVSAnswer.value != '') {
			totalInt = parseInt(totalInt) + parseInt(grMRVSAnswer.value);
		}
	}

	current.variables.total_disk_size = totalInt;
	current.update();

})(current, previous);

[hongsok]

Hi Mark,

It works now - I put the wrong sys_ID.

One last question. The result is still show decimal.