COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sameena on 04 Jun 2014 01:58:10 AM

Title: Function in cognos to check whether my data is numeric
Post by: sameena on 04 Jun 2014 01:58:10 AM
Hi all,
   I have column that has numbers,special charactes and texts. But I need to display only those values that are numeric and add a  text to them.

Thanks,
Sameena
Title: Re: Function in cognos to check whether my data is numeric
Post by: Lynn on 04 Jun 2014 08:21:32 AM
Take a look at the etiquette post and then reply back with the necessary details. IF your package is relational then there may be database functions you can use, but you didn't provide enough information to get a reliable answer.