Hi all.
I am currently working on an internal process.
The process is simple: Drop a PDF into a hot folder, which then creates an XML version of that PDF.
The PDF is an Invoice which is for the month of October. It has static values which I use to decide which of my values are Matches and Mismatches, also which are and are not in SQL. - Merely to keep the data live.
After running my Workflow, I have quite the amount of entries in my Repo.
Matches - which are Service ID's and Sub Totals that are the same from October to November.
Mismatches - Which have different ID's/Sub Totals.
Not in SQL - Which is obviously data that is not present in SQL.
All I want to do is add functionality to my Workflow that counts the sub total of my Sub Total field value.
Around 60 entries with Currency values that all differ. I want all 60 entries field value "Sub Total" counted together which then gives me the grand Sub Total of all my matches/mismatches.
I would greatly appreciate some help with this.