Rounding question 1

[travelerII]

I am using Crystal 10 and I want to be able to round up not just 1.5 to 2 for example, I want 1.1 to round up to 2. I was unable to find a function to perform this.
Thank you in advance for the help.

 

[briangriffin]

The ceiling function does just that. For example,ceiling(1.1) will evaluate to 2.

The floor function does the opposite.

 

[travelerII]

Crystal 10 does not appear to have a ceiling function. I could not find it in the function list and when I type it in the formula editor it doesn't turn blue.

 

[lbass]

Do you have roundup()?

If not, try:

-int(-{table.field})

-LB

 

[fisheromacse]

you may be able to use a formula:
something like:

IF {table.field} = truncate({table.field},0)
then {table.field}
else truncate({table.field})+1

 

[travelerII]

Thank you fisheromacse that did the trick.