Crystal Reports Subtracting two 'Counts'

Report Design

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

Topic: Subtracting two 'Counts'

Post Reply

Post New Topic

Author	Message
paulizorama Newbie Joined: 17 Dec 2009 Location: United Kingdom Online Status: Offline Posts: 14	Topic: Subtracting two 'Counts' Posted: 10 Jan 2010 at 10:12am
	Is it possible to create two SUM/COUNT expressions (derived from datafields in the same report details section) and then use the formula editor to subtract one from the other . If so what would that formula look like? Thanks - in anticipation
	pauliz
	IP Logged


lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 11 Jan 2010 at 5:44am
	sum({table.field1}, {grouping condition}) - sum({table.field2}, {grouping condition}) if the formula is for the entire report, the grouping condition can be removed. HTH
	IP Logged

paulizorama Newbie Joined: 17 Dec 2009 Location: United Kingdom Online Status: Offline Posts: 14	Posted: 11 Jan 2010 at 10:03am
	Thanks Lockwelle - will give it a spin - very grateful
	pauliz
	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