Report that sums the numbers in a Catalog Item String Variable

[Steven Parker]

So I want to create a report that sums the numbers from a catalog item string variable.  I currently have a report that is just a list and it displays the numbers like you see below:

That "Orchestration Count" field is just a single line text variable from the catalog item that I populate for how many times an Orchestration activity ran for the given RITM.  

Is it possible to create a script include that sums ALL the values of that string field (looking for ALL TIME count) and then call that script include in a Report condition somehow?

I basically just want the report to return something like this:

Unfortunately, the orch_execution table is truncated after a little over a year so it's impossible to use that table for the count ALL TIME.

Any thoughts?

[Brian Lancaster]

I'm not sure if it will work variables buy if you right click on Orchestration Count you should hopefully see configure > List Calculations.  You will then get a popup and one of the option is sum.