Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Summarize a Running Total? Post Reply Post New Topic
Author Message
thummel1
Senior Member
Senior Member
Avatar

Joined: 27 Apr 2012
Location: United States
Online Status: Offline
Posts: 140
Quote thummel1 Replybullet Topic: Summarize a Running Total?
    Posted: 06 Jan 2016 at 12:17pm
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?
"Press any key to continue. Where's the 'Any' Key?" ~Homer Simpson
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.