TM1 Web - Percentage data input
Posted: Fri Sep 26, 2014 9:07 pm
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?
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?