Applying thousand separator to numerical value in String column.

[Shashi Pandey]

Hi,

In my report column data type is String. But, it contains values String and numerical both. I want to apply thousand separator fornumerical values.

Example:

Values Expected output

Arjun Arjun

Robert Robert

4367832 43,67,832

 

Help will be much appreciated

[Corey Scherrer 3]

I believe something like this should work:

SN(case

WHEN (integer([Value]) % 1)=0 THEN

CASE

when Len([Value])

[Shashi Pandey]

Hi ,

 

Thank you for your amswer.

 

But it is not working for me.

 

Let me tell what i did.

 

1. Created calculated column and wrote expression you gave me. Replaced value in the expression with column have in report. String values are appearing as expected but numerical values does not have commas(thousand separator).

 

 

 

Note: Column which contains strings and numbers have data type "String".

[Corey Scherrer 3]

Are there extra characters around the "numbers" that may need to be trimmed off

[Fabian Duerr]

cscherrerGME answer works just fine. And yes, you need to trim your [Value] column to get rid of all that useless spaces. So either wrap Trim([..]) around all [Value] entries in above formular or create a trimmed column [Val] = Trim([Value]) and then continue to work with [Val]