Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Adding total with condition Post Reply Post New Topic
Author Message
crystalgal
Groupie
Groupie
Avatar

Joined: 20 Feb 2009
Location: United States
Online Status: Offline
Posts: 66
Quote crystalgal Replybullet Topic: Adding total with condition
    Posted: 27 May 2010 at 7:45am
 
I am trying to add distinct total  of students who took the end of year survey.
Right now,it shows distinct number of students but some students take multiple courses and multiple surveys and that is not getting added.
Any suggestions?
 
Thanks is advance.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 May 2010 at 8:00am

Not sure where your problem is lying.

Likely the easiest solution is to use a Running Total with a specific evaluation formula.
In data terms what is your inclusion process?
IP IP Logged
crystalgal
Groupie
Groupie
Avatar

Joined: 20 Feb 2009
Location: United States
Online Status: Offline
Posts: 66
Quote crystalgal Replybullet Posted: 27 May 2010 at 8:04am

I tried the running total but not working -  it is giving me the distinct value and not counting 1 student ID with multiple courses.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 May 2010 at 8:07am

So you want to count the number of instances the survey was taken or the number of people that took the survey?
IP IP Logged
crystalgal
Groupie
Groupie
Avatar

Joined: 20 Feb 2009
Location: United States
Online Status: Offline
Posts: 66
Quote crystalgal Replybullet Posted: 27 May 2010 at 8:09am

Count Number of students who took the surveys.

Thanks
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 May 2010 at 8:17am
Create a Running Total
Name=SurveyCount
Field to Summarize=StudentID
Type=DisinctCount
Evaluate=Use a formula
//We have to figure this out but basically you want a way to show TRUE when the survey was taken and FALSE all other times.. just guessing but will likely be something like
Table.surveyfield='2010 YearEnd survey'
//
Reset=Never
Place in Report Footer (RT's do not work inheaders)


Edited by DBlank - 27 May 2010 at 8:19am
IP IP Logged
crystalgal
Groupie
Groupie
Avatar

Joined: 20 Feb 2009
Location: United States
Online Status: Offline
Posts: 66
Quote crystalgal Replybullet Posted: 27 May 2010 at 8:36am

Am working on it. Thanks. Hopefully it will work.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 May 2010 at 8:40am

if you want help with the formula just post 2 or 3 data rows that have both 'count' and 'exclude' and tell me why to include or exclude and I can help with your formula.
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.012 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.