I am using Crystal Reports version 14. I need to be able to get a SUM by Process Level (Group 1) based on the results of 2 running totals that are calculated in Group 2 (Case Number). Allow me to explain:
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?