If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Defaulting number value with a string

Started by asmfloyd, 23 Aug 2019 04:45:31 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

asmfloyd

23 Aug 2019 04:45:31 AM
Hi,
  I have a number field X with a thousand separator as comma. I have a condition that if value of a FLAG column is "Y", I need to default  the number value as "#". So I am doing the below conversion. But when converted, it is removing the thousand separator from other values (Ex: 123,456 becomes 123456) .
   How can I default this keeping the thousand separators in place?

IF (FLAG='Y') then (to_char(X)) else ('#')
Thanks,
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite