TM1 Web - Percentage data input

Post Reply
User avatar
vovanenok
Posts: 89
Joined: Mon Jun 23, 2014 4:54 pm
OLAP Product: TM1
Version: 2.0.9
Excel Version: Office 365
Location: Toronto, Canada
Contact:

TM1 Web - Percentage data input

Post by vovanenok »

Hi Guys

I have an element formatted as percentage: c:#0.00%;(#,0.00%);"", so in a cube viewer I'm able to enter either "0.1" or "10%" and TM1 understands everything fine.
However in TM1 Web when I'm editing a cell with zero value it doesn't allow me to enter "10%", only "0.1"
After I enter "0.1" and hit enter it becomes as 10% and then I can edit it using both input methods, let's I can change it to "0.25" or "25%" and get what I want.

The Excel format is: 0.00%;0.00%;_(-_)
as I want to display '-' for zeros.

My question is: can I get this cell in TM1 Web to accept both input methods / formatting while editing cell with 0?
----------
TeamOne Google Sheets add-on for IBM Planning Analytics
Let's connect on LinkedIn
Post Reply