Always Round Up

[Curtis.Holmes]

Hi everybody,

I have a situation in which I need returned values to always get rounded up.  Exactly like the Excel function =roundup().  I'm aware Cognos has a half-even round method.  Has anyone found a way to mimic/recreate the Excel function?

Examples of desired results:

7.1 round up to 8
7.2 round up to 8
7.4 round up to 8
7.5 round up to 8
7.8 round up to 8

Thanks,

C

[dlafrance]

As mentionned in this technote : http://www-01.ibm.com/support/docview.wss?uid=swg21339559

use ceiling(numeric_exp),returns the smallest integer greater than or equal to numeric_exp.

[Curtis.Holmes]

Exactly what I was looking for....


Thank you for your help!

C