Summarize Tool for Open Items

[ZoeM]

Gurus!

Who said work doesn't happen on Sundays!

I am stuck. I need to summarize data to match the below snip. Essentially, I have data with issues, if any program has an open issue while others are closed that program remains 'Open'. If all issues are closed then that program is 'Closed'.

Any ideas?

[alexnajm]

The Summarize tool should just be configured to group by Program and group by Program Status!

[ZoeM]

Thanks!

I guess what I am trying to do is get the Program Status field results, i.e. if one issue is 'Open' then all results will be Open. Then I could use the summarize tool...

[alexnajm]

But they are all Open in the Program Status field already!

[ZoeM]

Thanks for keeping me honest alexnajm!

The Program Status field is actually blank! The statement I am looking to evaluate is "If one issue is Open then the program level is Open even if other issues are closed". Only when all issues are closed should it evaluate the program as closed.  

[alexnajm]

Try this then!

[flying008]

Hi, @ZoeM 

Please see the formula:

IIF(Contains([Program Status], 'OPen'), 'Open', 'Closed')