TM1 Forum

hello,

I have set up an picklist for an element with just three values. When I open the report set the value it works perfectly. Now I like to change the value back to blank. This doesn't work because the value is not in the list.

I changed the picklist to static::A:B:C to show the empty value as well. The empty value shows up in Perspectives but when I select it, the blank value is written to the excel cell and overwrites the formula instead of writing the value back to the cube.

Exactly the same happens if I use an excel list with an empty value...

The only way to the delte the data is to delte the picklist, delete value and add it again or to click in the cell click space and delete.
Any idea how to fix this? I don't want to use dummy values like "." or "empty".

Thanks in advance.
Dominik

maps wrote: I changed the picklist to static::A:B:C to show the empty value as well. The empty value shows up in Perspectives but when I select it, the blank value is written to the excel cell and overwrites the formula instead of writing the value back to the cube.

If you will create the Static Picklist like static::A:B:C it will clear the formula in Perspectives.

If you need to have a blank value in the Picklist then make sure you create the static Picklist with a space in it. So you syntax should look like this (will have a space between coloons):