Print Page - Nearest 100 million in report studio

Title: Nearest 100 million in report studio
Post by: daya007 on 27 Jul 2010 05:44:57 PM

Hi,
I have a dynamic calculation which results x,xxx,xxx,xxx,xxx.xx number. Client dont want to c that number, he wants to c the calculation rounding to nearest 100 million. For example if the calculation yields 502,173,318,202.96, he wants the number to be shown as 502,200,000,000. if calculation is 502,143,318,202.96, he wants the num to be shown as 502,100,000,000.
I am not able to do this. I am new to cognos. Please help. If u need more clarity on question reply to this thread.

Thanks
Daya

Title: Re: Nearest 100 million in report studio
Post by: CognosPaul on 28 Jul 2010 03:40:02 AM

This is more of a logic problem than a Cognos one.

Try something like this: round( Number / 100,000,000) * 100,000,000

Title: Re: Nearest 100 million in report studio
Post by: daya007 on 28 Jul 2010 04:05:07 PM

Thank you...its working..

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: daya007 on 27 Jul 2010 05:44:57 PM