Summarizing Data

[AlisonK39]

Hi! 

I have a workflow where I have two outputs - the first output has multiple lines (sorted by contract).  I'm trying to summarize the data in a second output that would aggregate the information into a contract level status.  

Some contracts have one line, which is easy enough to summarize, but in cases where there are multiple lines, there would (in this case) show the contract as a whole as closed.  Then I want to take the average based on all of the lines open.  

Any help is appreciated! 

Thank you!

Alison

[markcurry · Accepted solution]

I Hope this will give you the Summary you are after, I've set it where there is more than 1 status, to set the status = Closed.....

[AlisonK39]

That was exactly what I needed.  Thanks so much!