This can be achieved by creating a calculated field called 'Number of Open Activites' or similar with the formula
if [Activity Status] = 'Open' then 1 else 0 end
and then using this field in a filter condition on SR NUM i.e.
sum([Open Activities]) > 0
along with SR Status = Closed will give you the SRs which don't meet your compliance criteria.
See the attached workbook for a work-through of this example.
Sample_SR_Data_PW.twbx.zip 22.6 KB
Originally I was trying to get it all in one calculation without using filters - so that I can have this alert calculation on the worksheet with other alerts ... using filters makes it more challenging to make this happen on one worksheet. Having said that your solution works fine and I've added to the real data with no issues.
Thanks for taking the time to answer.
All the best