Using script include in report servicenow

hind
Tera Contributor

Hi all !

 

In the RITM table (sc_req_item), each RITM has an associated "volumetry" field of integer type. I want to create an advanced report that displays the number of RITMs multiplied by the volumetry.

For example, if I have 3 requests with a volumetry of 3 for each, the result I should get should be: (1*3) + (1*3) + (1*3) = 9.

For this, I created a script include and called it in my report as mentioned below, but I get a result equal to 0.

Can someone help me?

 

Script include :

hind_0-1741694398836.png

Report : 

hind_1-1741694485856.png

thanks in advance !

0 REPLIES 0