Rounding-Up (Ceiling Function) help needed.

[DallasAggie]

Hello.

I am trying to round a number up from lets say 1.1 to 2, which is the ceiling. Does anyone know how to do this?

I've tried this:

If remainder({@sum_of_fears},1) > 0 then
truncate({@sum_of_fears}) + 1 else
{@sum_of_fears}

This would typically work, but I am trying to use the function inside of a crosstab, so my results always get jacked! :-|

Any advice would be greatly appreciated.

-DallasAggie