Print Page - Always Round Up

Title: Always Round Up
Post by: Curtis.Holmes on 16 Aug 2010 01:51:50 PM

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

Title: Re: Always Round Up
Post by: dlafrance on 16 Aug 2010 03:20:45 PM

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.

Title: Re: Always Round Up
Post by: Curtis.Holmes on 17 Aug 2010 11:35:03 AM

Exactly what I was looking for....

Thank you for your help!

C

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Curtis.Holmes on 16 Aug 2010 01:51:50 PM