Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RoundUp a number in Crystal 10

Status
Not open for further replies.

mycrystalbaby

Programmer
Jun 16, 2005
42
US
I would like to write a formula for Roundup for any decimal point.
e.g, if my result is 1.1, then also it should roundup to 2.
If it is 1.5 then also 2

I tried adding .5 in the result set, but it does not give the accurate results.
It is very urgent, if somebody could help me, will be highly appreciable.
Thanks
 
This should do it

-int(-{My_Number}/1)*1

HTH

Gary Parker
MIS Data Analyst
Manchester, England
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top