Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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