How to aggregate SUM of value coming from a variable visible in catalog item.

[Ahyel Libunao]

Hello, 

I have a requirement that needs a report of the total amount of the values from "Total Cost" which is a variable in the catalog task. I have tried few options below but didnt work.

1. Using aggregate in native reporting - this wont show the variables

2. Using List Calculation - Total Value is not appearing even the variable type is single line text, validation regex = Amount. I have tried to change the validation regex to float and integer but Total Value from the list calcu is not visible. 

3. I have tried to use the table sc_item_option_mtom for my report, but still, the Total Cost variable cannot be dotwalked in the aggregation. 

Do you have other recommendations that I can use please? If PA is an option,can you provide steps as I am new to Performance analytics. 

Thanks in advance!

Ahyel

[Aman Kumar S]

Hey,

Below is an article for building a report, you can use SUM to get the final values

Report on Item Variables in the Service Catalog with a Database View

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂