Nearest 100 million in report studio

[daya007]

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

[CognosPaul]

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

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

[daya007]

Thank you...its working..