COGNOiSe.com - The IBM Cognos Community

Hi All,
I'm using Cognos in my expense system, Concur (report studio). I'm using the following statements to tie card numbers with employee location.

case
when([Expense].[Employee Information].[Org Unit 1 - Name] = 'ABC') then (12345)
when([Expense].[Employee Information].[Org Unit 1 - Name] = 'DEF') then (6789)
when([Expense].[Employee Information].[Org Unit 1 - Name] = 'XYZ') then (4567)
else (0) end

When I run the report the data is displayed as '12,345' '6,789'...
How can I format the field to display the data without commas?

Thanks

• Select the object you want to format in the report page
• In the properties click Data Format
• Set the Format Type to number
• Set thousands seperator to none

Hi, thanks for responding.

I' played around with that earlier and din't see 'number' as a Format Type.  I see Default and Text.

You don't see the option 'number' as a Format Type? That is strange. What kind of object have you placed the data item in? Is it a list?

Another option that you can try is: Data (in the top menu) > Default Data Formats.

Hello,


Have you tried to make your output expression in string, like :
case
when([Expense].[Employee Information].[Org Unit 1 - Name] = 'ABC') then ('12345')
when([Expense].[Employee Information].[Org Unit 1 - Name] = 'DEF') then ('6789')
when([Expense].[Employee Information].[Org Unit 1 - Name] = 'XYZ') then ('4567')
else (0) end

Hi FrenchGuy,

I've tried that and get this error: QE-DEF-0405 Incompatible data types in case statement.

Change the else (0) to Else ('0').

That way all the possible results are a string.

Thanks NIEK87 and FrenchGuy.

Here's what worked: combined both NIEK And FrencGuy's suggestion.

Thanks again for all your help.  :D

Teamplay Overpowered  8)