Crystal Reports Count specific number values

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Count specific number values

Post Reply

Post New Topic

Author	Message
pzuniga Newbie Joined: 25 Jul 2011 Location: United States Online Status: Offline Posts: 3	Topic: Count specific number values Posted: 25 Jul 2011 at 12:28pm
	I have a table field that has a distict set of values (numberic). How can i count all values except 3110? 3110 3110 3110 3110 3110 3110 3110 3110 3223 3223 3321 3321
	IP Logged


FrnhtGLI Senior Member Joined: 22 May 2009 Online Status: Offline Posts: 347	Posted: 26 Jul 2011 at 1:56am
	Create a running total and evaluate where {table.field}<>3110
	\|< /\ '][' ( )
	IP Logged

pzuniga Newbie Joined: 25 Jul 2011 Location: United States Online Status: Offline Posts: 3	Posted: 26 Jul 2011 at 4:55am
	Frnhtgli, is there a formula to say "dont count the most frequent value?"
	IP Logged

sharona Senior Member Joined: 16 Oct 2008 Location: United States Online Status: Offline Posts: 255	Posted: 26 Jul 2011 at 7:09am
	you need to create a formula that says if {field} <>'3110' then 1 else 0 then sum that if you want a count by number, group by number then sum on the group
	sharona
	IP Logged

pzuniga Newbie Joined: 25 Jul 2011 Location: United States Online Status: Offline Posts: 3	Posted: 27 Jul 2011 at 8:45am
	the <>'3110' wont work since the value changes with parameter selection, I used this: If ({Trips.LineGroupId})= mode ({Trips.LineGroupId},{Service.ServiceName}) then 0 else 1 which works great in the detail , however it will not allow me to sum the field, why? is there anyway around this?
	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