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

[AndersBGS]

Hi @Burhan Shah , 

If you utilize the sc_req_item table instead, then you can dot-walk to variables:

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 

We can dot-walk in filters only. The Aggregation (Sum) doesn't have a variable option.

Regards,
Burhan

[Prarthana Patil]

Hi @Burhan Shah ,

Please create a report on RITM table as:-

 

Go to configure tab and set aggregation as "SUM" -> Select you field rather than quantity(example Invoice Value)

 

If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."

Regards,

Prarthana Patil

[Burhan Shah]

Hi @Prarthana Patil 

In the sum configure field, you can't dot walk variables of RITM.

Regards,
Burhan

[jaswalvishal106]

Hello @Burhan Shah : The report type is single score shown below with aggregation as sum: