Solved

Creating a Sum using a running total and a conditional formual

Posted on 2013-05-15
3
295 Views
Last Modified: 2013-05-20
I need to clasify if a case has more than one request associated with it.  I was able to accomplish this through groups and a running total.  The data looks like this

Group a
Request 1
Request 2
   Running total 2

Group B
Request 1
    Running total 1

Group C
Request 1
request 2
Request 3
   Running total 3

Now I want to determine how many cases (groups) have more than one associated request.  I created an if/ then formula based on the running total, but I can't sum this as already includes summary data.  From looking at other posts, I think that I need a variable, but I am unsure how to do this and what forumla(s) I might need.  

I just want a total sum of all cases (groups) that have more than 1 request associated with it.  Any help will be greatly appreciated.
0
Comment
Question by:josslmpd
  • 2
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39169941
Try this

In the report header create a formula
WhilePrintingRecords;
Global NumberVar MoreThan1Count;
""

In the group footer
WhilePrintingRecords;
Global NumberVar MoreThan1Count;
If {#RunningTotal} > 1 then
     MoreThan1Count := MoreThan1Count + 1;
""

In the report footer
WhilePrintingRecords;
Global NumberVar MoreThan1Count;
MoreThan1Count

If you need the total number of cases just add another variable and calculate as you go.

mlmcc
0
 

Author Comment

by:josslmpd
ID: 39171441
Thank you, that worked perfectly.  Do you know of any resources, on this website or others, that explains variables and how to use them?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39171761
I don't have any links readily available here.  I will try to check from home

mlmcc
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question