Crystal Reports decimal issue

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

Topic: decimal issue

Author	Message
aftershokk Newbie Joined: 06 Apr 2010 Online Status: Offline Posts: 11	Topic: decimal issue Posted: 16 Apr 2010 at 5:51am
	I have a basic formula Sum ({repeat_admits_table.# of Admits}, {repeat_admits_table.YEAR}) / (divided by) DistinctCount ({repeat_admits_table.Member Id}, {repeat_admits_table.YEAR}) I gives me a results rounded to 2.0 but I want the decimals? Not sure how to get this to work
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 16 Apr 2010 at 6:10am
	What does your number format look like for that formula? Also did you click on the increase decimals icon on the toolbar?
	IP Logged

aftershokk Newbie Joined: 06 Apr 2010 Online Status: Offline Posts: 11	Posted: 16 Apr 2010 at 6:16am
	the increase decimal button will take it to 2.5 but when I want to go out one more place it turns into 2.50? thanks
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 17 Apr 2010 at 2:09am
	you can always try the totext() function, there are several options to force the format. You should be able to use the format text option after you drop the formula on the report. HTH
	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.016 seconds.