Crystal Reports formula count

Technical Questions

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

Topic: formula count

Post Reply

Post New Topic

Author	Message
jedder Newbie Joined: 19 Nov 2012 Online Status: Offline Posts: 6	Topic: formula count Posted: 15 Jan 2013 at 3:03am
	Crystal 2008 version Have report that enters an x in a formula field Would like to be able to count all the fields that contain an x How do you count formula fields?
	Jennifer
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 15 Jan 2013 at 4:32am
	make the formula put a 1 instead and sum it. you can alsomake a seoerate one with the X and use that for display or you can use a conditional display formula on the one that returns a 1
	IP Logged

jedder Newbie Joined: 19 Nov 2012 Online Status: Offline Posts: 6	Posted: 15 Jan 2013 at 4:45am
	I'm guessing I'll have to say in formula that x =1 and then sum cuz it needs to show the x on the report not a 1 thanks for info
	Jennifer
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 15 Jan 2013 at 4:49am
	you can do that using a Running Total or 3 shared variable formulas, I was suggesting a simpler approach. I understand it needs to show an X, that is why I suggested to use a display formula on it (then 1 or 0 options) or just create 2 formulas, one for display and one for a sum. make sense? Edited by DBlank - 15 Jan 2013 at 4:50am
	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