Rounding UP to next Whole number on Formula 1

[cinbh]

I need to round UP (only) my formula field results to the next whole number whenever I have a decimal value .
For Example:
10.70 = 11.00
.80 = 1.00
1.40 = 2.00
ETC.
I have seen some threads using truncate, but I don't see how I'm able to get it to work for this situation. Of course, I'm still learning in Crystal and pretty much a novice with this sort of programming. We currently are using Crystal 8.0 with VisualFoxPro 7.0.
Any help is greatly appreciated.
Cindy B-H

 

[mbarron]

Try this one: It basically if the number minus the number without decimals not equal to zero then get rid of the poin whatever and add one otherwise just show the number.


if {number.field} - truncate({number.field}) <> 0 then truncate({number.field})+1 else
{number.field} Mike

 

[cinbh]

THANK YOU! Worked like a charm.
Cindy B-H