TM1 percentage formatting

Post Reply
Jussi
Posts: 1
Joined: Fri Jan 24, 2014 9:18 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

TM1 percentage formatting

Post by Jussi »

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
Wim Gielis
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

Post by Wim Gielis »

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
Post Reply