Hello everybody,
I'm having a bit of a problem with percentage formatting. I'm using TM1 10.2 Performance Modeller / Architect for editing dimensions and element formattings.
The problem is that the cell formatting seems to activate only after a user enters some data into that specific cell. If I enter for example 50, I get 5000%. Now if I enter 50 again, I get 50% which was the intention in the first place. Furthermore, if I now remove the value from the cell already edited, the formatting works correctly because it is kind of activated.
So is this intended behaviour and might some one know an alternative formatting to achieve a more user friendly behaviour. I'm also using 'empty if zero' condition in the formatting.
Regards,
JJ
TM1 percentage formatting
-
- MVP
- Posts: 3241
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1 percentage formatting
Intended behavior. You should enter the value as 0.50 to get 50%
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly