Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: using round formula Post Reply Post New Topic
Author Message
yasinirshad
Newbie
Newbie
Avatar

Joined: 24 Sep 2007
Location: Saudi Arabia
Online Status: Offline
Posts: 39
Quote yasinirshad Replybullet Topic: using round formula
    Posted: 28 Dec 2009 at 4:00am
Hi,
I have following values in db table:
1
2
3.9
4.8888
 
How to display in CR as below
1
2
3.9
4.8
 
Can anyone help with formula to show result as above..i tried but getting as
1.00
2.00
4.90
4.80
 
if (ToNumber({Energy_Transfer.kuw_A_E}) - truncate(ToNumber({Energy_Transfer.kuw_A_E}))) <> 0 then
round(Tonumber({Energy_Transfer.kuw_A_E}),1) else tonumber({Energy_Transfer.kuw_A_E})
My formula is
 
Thanks to help.
Thanks,
Yasin.
IP 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.