TM1 - excel validation list

[sfnicole]

Hi,
I have used the validation list in the input template. It works fine when select the data from the list and the value will be saved in TM1.

However, when we choose a blank value from the list, the formula (DBRW...) is gone.

How to deselect a value from the list without loosing the formula?

Thanks in advance.

[paulsimon]

Hi

If you are writing to a numeric cell, try putting 0 in your list instead of blank

Regards


Paul

[sfnicole]

Hi Paul,
Instead of putting zero, i put " " and it works. Thanks.