Within each Case (Group 2, table called LOG) a person could have Lost and/or Restricted Work Days (stored in Table called LOSTTIME). I created a running total to SUM up the total Lost Work Days on change of CASE (when type = "L"), and a second running total to SUM op the total Restricted Work Days on change of Case(When type = "R") . From here, I created a formula for these 2 running totals:

 

If({#SUMRWD}) > 0 and isnull({#SUMLWD}) then 1 else 0

 

I put this formula in Group 2 (Case Number) and it works perfectly; gives me a 1 for each case that meets this criteria.

 

Now is the part I can't figure out. I need to SUM up the 1s in Group 1 (Process Level). I can't do a Running Total on my formula above. I also can't create a Summary on the formula. Finally, I haven't been able to create another fomula from this formula, as I get the message "This field cannot by summarized". 

 

I understand a summary on a summary/running total is generally not possible, but I thought there were ways around this.  What are my options?