Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Formula rounding Post Reply Post New Topic
Author Message
BLogon
Newbie
Newbie


Joined: 02 Sep 2010
Online Status: Offline
Posts: 4
Quote BLogon Replybullet Topic: Formula rounding
     Posted: 02 Sep 2010 at 10:27pm
I have an issue with formula editor. When I try to divide one number to another Crystal Reports round it, for example follow expression:
10.67\5 must equals 2.134 but in Report it looks like 2.
Can I do something to resolve it?
IP IP Logged
Senthil Raj
Newbie
Newbie
Avatar

Joined: 02 Aug 2010
Location: India
Online Status: Offline
Posts: 27
Quote Senthil Raj Replybullet Posted: 02 Sep 2010 at 11:38pm
3 things you check

1.if you are assigning the value to a variable check the data type it should not be a integer type

2. Check the format of the field it should be 0.00 format

3. try as 10.67/5.00

Edited by Senthil Raj - 02 Sep 2010 at 11:39pm
Live And Let Live...
IP IP Logged
BLogon
Newbie
Newbie


Joined: 02 Sep 2010
Online Status: Offline
Posts: 4
Quote BLogon Replybullet Posted: 02 Sep 2010 at 11:55pm
Thanks for answer
1. The data type is Number
2. With format all ok - 0.00
3. Tried, the same
Most interesting that in this expression all ok
10.67*5 = in the report 53,35 so right, what is this?

p.s. version Of Crystal Reports is 10.0.0.533
IP IP Logged
Senthil Raj
Newbie
Newbie
Avatar

Joined: 02 Aug 2010
Location: India
Online Status: Offline
Posts: 27
Quote Senthil Raj Replybullet Posted: 05 Sep 2010 at 7:42pm
try as 10.67/5.00
Live And Let Live...
IP IP Logged
BLogon
Newbie
Newbie


Joined: 02 Sep 2010
Online Status: Offline
Posts: 4
Quote BLogon Replybullet Posted: 05 Sep 2010 at 7:55pm
3. I tried the result is the same
IP IP Logged
Senthil Raj
Newbie
Newbie
Avatar

Joined: 02 Aug 2010
Location: India
Online Status: Offline
Posts: 27
Quote Senthil Raj Replybullet Posted: 05 Sep 2010 at 8:00pm
Originally posted by BLogon

I have an issue with formula editor. When I try to divide one number to another Crystal Reports round it, for example follow expression:
10.67\5 must equals 2.134 but in Report it looks like 2.
Can I do something to resolve it?


just a confirmation you mentioned as 10.67\5 that will return integer value have you tried as 10.67/5.00
Live And Let Live...
IP IP Logged
BLogon
Newbie
Newbie


Joined: 02 Sep 2010
Online Status: Offline
Posts: 4
Quote BLogon Replybullet Posted: 05 Sep 2010 at 8:16pm
You was right, thank you very much and sorry for inadvertence.
IP 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