Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Truncating a Formula Field Post Reply Post New Topic
<< Prev Page  of 2
Author Message
crystalnewbie33
Newbie
Newbie


Joined: 08 Jan 2014
Online Status: Offline
Posts: 29
Quote crystalnewbie33 Replybullet Posted: 09 Jan 2014 at 5:18am
I'm sorry. I realize my questions are very basic. Exactly where to I put the round formula? How do I put it in the formula field along with my formula? It says that it does not appear to be a part of the formula.
IP IP Logged
crystalnewbie33
Newbie
Newbie


Joined: 08 Jan 2014
Online Status: Offline
Posts: 29
Quote crystalnewbie33 Replybullet Posted: 09 Jan 2014 at 5:21am
Thank you all so much. The basic syntax option posted by lockwelle did indeed work. Thanks!!
IP IP Logged
crystalnewbie33
Newbie
Newbie


Joined: 08 Jan 2014
Online Status: Offline
Posts: 29
Quote crystalnewbie33 Replybullet Posted: 09 Jan 2014 at 5:32am
I tried the Crystal syntax version as well and it worked great. Also, performed truncate in the same way. Thanks again.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Jan 2014 at 5:56am
I saw your other post on "bankers rounding" so a word of caution here.
please be aware that the options given in this post are applying the rounding before any sum is taking place which can give you a different result than doing the sum first and then the rounding on that sum.
IP IP Logged
crystalnewbie33
Newbie
Newbie


Joined: 08 Jan 2014
Online Status: Offline
Posts: 29
Quote crystalnewbie33 Replybullet Posted: 09 Jan 2014 at 6:12am
Thank you for the heads up, I will keep that in mind. In this situation, to match results I am getting from the MySql rounding, applying the rounding before summing works best. You have been a huge help to me, thanks again.
IP IP Logged
<< Prev Page  of 2
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.