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
Nearest 100 million in report studio
-
- 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
Hi,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
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
Peter
-
- 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
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.
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
Peter
-
- 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
thanks for the reply. I was mistaken, the way u said is right. Ill try to solve with ur solution.
-
- 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
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.