TM1 percentage formatting
Posted: Tue Jan 28, 2014 10:16 am
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
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