Pick List

Post Reply
Auvi
Posts: 2
Joined: Tue May 14, 2013 6:15 am
OLAP Product: Cognos TM1
Version: 9.5.2
Excel Version: Office 2010

Pick List

Post by Auvi »

I have defined picklists (numeric output static:1,1343:1,08) for two elements in a dimension. The problem i am facing is that , the comma (for example between 1 and 1343) don´t delivered. What is the problem?
Thank you in anticipation!
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Pick List

Post by declanr »

Auvi wrote:I have defined picklists (numeric output static:1,1343:1,08) for two elements in a dimension. The problem i am facing is that , the comma (for example between 1 and 1343) don´t delivered. What is the problem?
Thank you in anticipation!
Can't say I have played much with picklists and decimal places but I wonder if its to do with the fact that although you are formatting your numbers with the euro style

Code: Select all

,
for a decimal and

Code: Select all

.
for a thousand separator... the backbones of the system will still probably be recording it as 1,000.00 instead of 1.000,00 so perhaps try and input this for your picklist:

Code: Select all

static:1.1343:1.08
Declan Rodger
Auvi
Posts: 2
Joined: Tue May 14, 2013 6:15 am
OLAP Product: Cognos TM1
Version: 9.5.2
Excel Version: Office 2010

Re: Pick List

Post by Auvi »

Wow, thank you for your fast and right answer.
Post Reply