Nearest 100 million in report studio

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.


i normally use the “scale” property. This makes the numbers better readable. I just place a x 100,000,000 in the column header.