Nearest 100 million in report studio

Post Reply
daya007
Posts: 49
Joined: Fri May 28, 2010 4:47 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003
Location: IL, USA

Nearest 100 million in report studio

Post by 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,318,202.96. if calculation is 502,143,318,202.96, he wants the num to be shown as 502,100,318,202.96.
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
kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: Nearest 100 million in report studio

Post by kpk »

daya007 wrote: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,318,202.96. if calculation is 502,143,318,202.96, he wants the num to be shown as 502,100,318,202.96.
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
Hi,

Are you sure that it is the real requirement?

Maybe the client would like to see
502,200,000,000.00 instead of 502,173,318,202.96 and
502,100,000,000.00 instead of 502,143,318,202.96.

You can use the ROUNDP function to solve it.

If the requirement is the one I suppose then the function should look like:
['B']=ROUNDP(['A']/100000000,0)*100000000

If the requirements is the one you asked for in the post then the rule is the following:
['B']=ROUNDP(['A']/100000000,0)*100000000+['A']-ROUNDP(['A']/1000000,0)*1000000

Kind regards,
Peter
Best Regards,
Peter
kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: Nearest 100 million in report studio

Post by kpk »

An additional thought:
Make sample calculation with your requirements in Excel. If it works in Excel then it is very easy to replace the Excel functions with TM1 own functions.
Best Regards,
Peter
daya007
Posts: 49
Joined: Fri May 28, 2010 4:47 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003
Location: IL, USA

Re: Nearest 100 million in report studio

Post by daya007 »

thanks for the reply. I was mistaken, the way u said is right. Ill try to solve with ur solution.
daya007
Posts: 49
Joined: Fri May 28, 2010 4:47 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003
Location: IL, USA

Re: Nearest 100 million in report studio

Post by daya007 »

actually cube was integrated to cognos 8. I have to do it at report studio level. how can i do it at report studio level.
Post Reply