Crystal Reports Adding total with condition

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Adding total with condition

Post Reply

Post New Topic

Author	Message
crystalgal Groupie Joined: 20 Feb 2009 Location: United States Online Status: Offline Posts: 66	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 Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

crystalgal Groupie Joined: 20 Feb 2009 Location: United States Online Status: Offline Posts: 66	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

crystalgal Groupie Joined: 20 Feb 2009 Location: United States Online Status: Offline Posts: 66	Posted: 27 May 2010 at 8:09am
	Count Number of students who took the surveys. Thanks
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

crystalgal Groupie Joined: 20 Feb 2009 Location: United States Online Status: Offline Posts: 66	Posted: 27 May 2010 at 8:36am
	Am working on it. Thanks. Hopefully it will work.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

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