TM1 Forum

Hello,

I'm facing a problem with data input in Perspective (active form).
Indeed i try to input a percentage in a cell but nothing happens.

For exemple if I input 2 the result is still the same. The only input possibility is 100.
The format range for the column is define as percentage with 1 comma.

Is there an issue ?

I just want to input a value, for exemple 0.2, send it to the cube, and read 20% in perspective.

Thank you in advance for your help.

Have you tried formatting the cube view you are creating your Active Form from as % and then recreating the Active Form? You can format on the measures dimension elements individually provided it is the last dimension in the cube. I have used "b:#0.00%;(0.00)%P|2|Y" in the Element Attributes cube for my measures dimension.

In the Active Form produced, this formats the cell in the corresponding column on the row labelled "N" to "#0.00%;(0.00)%".

I am using 10.2 but this worked fine for me. Everything is formatted as a % and when I type over the cell, ad enter 10, the % sign remains inside the cell. Pressing enter then writes 0.1 (i.e. 10%) back to the cell. Admittedly I've tested this using Excel 2010 and TM1 10.2, but in theory it should be the same in your versions.

Dan