How to remove comma in report field

[naqsa]

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

[NIEK87]

• 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

[naqsa]

Hi, thanks for responding.

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

[NIEK87]

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.

[TheFrenchGuy]

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

[naqsa]

Hi FrenchGuy,

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

[NIEK87]

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

That way all the possible results are a string.

[naqsa]

Thanks NIEK87 and FrenchGuy.

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

Thanks again for all your help.  :D

[TheFrenchGuy]

Teamplay Overpowered  8)