Print Page | Close Window

using round formula

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8739
Printed Date: 05 May 2024 at 2:46am


Topic: using round formula
Posted By: yasinirshad
Subject: using round formula
Date 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.


Print Page | Close Window