Sum of RITM Variable in a report

[Burhan Shah]

Hello Community,

I am creating a report which can show the sum of all variables entered for a specific catalog item.

For example: The name of the variable is "Invoice Value" We have 5 RITMS and they have 5000 added as Invoice Value. How can I create a report showing the sum of the total Invoice Value of all RITMS?

Regards,

Burhan Shah

[Anurag Tripathi]

Hi,

Check this thread where similar question is answered

Solved: Adding catalog item variables into report? - ServiceNow Community

[Burhan Shah]

Hi @Anurag Tripathi 

This thread is only about adding variables to the report but not the sum value of a variable.

Regards,

Burhan

[AndersBGS]

Hi @Burhan Shah ,

Just create a report based on the sc_cat_item table whit condition "item is xxxx". Afterwards make the report to sum  "invoice value".

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[Burhan Shah]

Hi @AndersBGS 

Firstly. I can't dot-walk the catalog item. Secondly, there is no option to dot walk the catalog item variables too.

Regards,

Burhan