When I input the number "2" in % format that the system present 200%.
Please suggest me how to input "2" and system will presented 2%?
% Format in TM1
-
sukunyatm1
- Posts: 2
- Joined: Sat Sep 03, 2011 12:52 pm
- OLAP Product: TM1
- Version: TM19.5.2
- Excel Version: MS Office 2010
-
Michel Zijlema
- Site Admin
- Posts: 713
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: % Format in TM1
You can type "2%". This will enter 0.02 in the cell and will be presented as 2%.sukunyatm1 wrote:When I input the number "2" in % format that the system present 200%.
Please suggest me how to input "2" and system will presented 2%?
Michel
(PS. I moved the topic from the Enhancements forum to the TM1 main forum)
-
sukunyatm1
- Posts: 2
- Joined: Sat Sep 03, 2011 12:52 pm
- OLAP Product: TM1
- Version: TM19.5.2
- Excel Version: MS Office 2010
Re: % Format in TM1
Thank you very much Michel.
My customer need to input number only, I would like to confirm that we can input "2%" and "0.02" only. Right?
My customer need to input number only, I would like to confirm that we can input "2%" and "0.02" only. Right?