So I have a simple workflow that takes in a ton of data, filters and processes it, then outputs it. Perfect. But then i still have to open it and do my own sum function to find what I need. There are a ton of rows with varying values in the Quantity field. I want to know the sum of all quantities less than or equal 1 million, and I also want to know the sum of all quantities greater than 1 million.
I get a massive file every day that I run through this workflow, is there a good way to have a summary sheet that just tells me this so I dont have to sum them manually?
Solved! Go to Solution.
Hi @abragg0103,
You may want to use the Summarize tool to create an exception report and use this new data stream to create a summary file: