Edit Selection Formula - Running Totals

[spcc07]

Version 8.5 SQL database
I have a report with 3 sets of three running totals with Admits >= 3 OR Deposits >= 1 in (Reports - Edit Selection Formula - Group)

The results look like this:
Applied Admit Deposits
2005 2006 2007 2005 2006 2007 2005 2006 2007
H School 0 0 0 0 0 0 0 2 1

Grouped on School_name
Problem:
For each deposit there should be Applied and Admitted numbers.

 

[dgillz]

Need lots more info. Tek tips does not charge by the word so please take the time to explain fully. Include sample raw data, current results and desired results.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[spcc07]

The data should look like this:
Applied Admit Deposits
2005 2006 2007 2005 2006 2007 2005 2006 2007
H School 0 2 1 0 1 1 0 1 1
The running totals
Summary is of the formula
If {CandidateProgram.Entry_Term} ="FA2005" and
{CandidateStage.Stage} = "APPLIC"
then 1
else 0
If {CandidateProgram.Entry_Term} ="FA2006" and
{CandidateStage.Stage} = "APPLIC"
then 1
else 0
If {CandidateProgram.Entry_Term} ="FA2007" and
{CandidateStage.Stage} = "APPLIC"
then 1
else 0
This formula changes stage from Applic to Admit to Deposit in each set of running totals.
Evaluate
Use a formula
Entry Term ="FA2005"(for each entry term)
Reset on change of group School.School_Name

 

[dgillz]

So what is the problem? What does the report look like now?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[lbass]

I guess you are using running totals because of the group selection? Set them up like this:

//{#2005applic}:
distinctcount of CandidateID
evaluate using a formula:
{CandidateProgram.Entry_Term} ="FA2005" and
{CandidateStage.Stage} = "APPLIC"
Reset on change of school.

Repeat for 8 more running totals, changing only the evaluation formula. Place the running totals in the school group footer and suppress the group header and details section.

-LB

 

[spcc07]

I have the running totals on the report already, and they work fine before I add the Admits >= 3 OR Deposits >= 1 in (Reports - Edit Selection Formula - Group)

 

[lbass]

What is the issue? You believe the running totals are returning the wrong values? Your group selection formula probably looks something like:

sum(admits,schoolname) > 3 or
sum(deposits,schoolname) >= 1

The running totals will ONLY include those rows that meet these criteria. For further help, please paste your group selection formula into the thread (instead of describing it) and explain how the results you are getting differ from what you expect.

-LB

 

[spcc07]

Thanks LB! The sum(admits,schoolname) >=3 or Sum(deposits,schoolname) >=1 works great! I was not attaching the group or setting it up as a sum.