Script to calculate numeric value

[sukran]

Script query return 3 numeric value for one record size value

Requirement is that , we need to calculate (add) all these and update the total through BR

[vishakhayadav24 · Accepted solution]

hi @sukran 

Please try the below code its working for me i have tried the same in PDI .

var arr = [];

var arr1 = [];

var totalSum=0;

var gr = new GlideRecord('cmdb_ci_computer');

gr.addQuery('sys_id', '79f66bd31b6dc8147fcc202a2d4bcbae');

gr.query();

while (gr.next()) {

    var compsys = gr.sys_id;

    var gr1 = new GlideRecord('cmdb_ci_disk');

    gr1.addQuery('computer', compsys);

    gr1.query();

    while (gr1.next()) {

        var siz = gr1.size;

        var fsiz = parseInt(siz);

        arr.push(fsiz);

        gs.info(arr);

    }

    var val = arr.split(",");

    for (i = 0; i < arr.length; i++){

        totalSum += arr[i];

    }

   gs.info(totalSum);

}

Please try to run it in background first.

Thank you!

Vishakha Yadav

[Trupti94]

Hi,

Please check below link,

https://www.servicenow.com/community/itsm-forum/in-incident-table-there-is-field-add-two-numbers-sho...

[Anurag Tripathi]

HI,

With the information provided.

Assuming your values are in 3 variables , b c & d

b = parseInt(b);

c = parseInt(c);

d = parseInt(d);

var a = b + c + d 

[sukran]

hI @Anurag Tripathi 

its not 3 different variables

After queries table for computer table storage volume disk .. its return 3 values

we need total count to set value one custom field 

[Anurag Tripathi]

AS i mentioned before , its hard to understand so please add more information, what is the table, what field.

how is one field giving you 3 values?

What is the trigger.