Having a space as the thousands separator, and be able to order when you click on the column

[alvesri]

Hi guys can you please help me ?

I'm trying to use a space as thousands separator and I can't, the max that I could it's a comma with this:

 eval value= if(value!="N/A",printf("%'d",value),value)

Result = 123,456

so I guess I can change it with a replace maybe,

But then we have problem number 2 ,

When I try to sort the by value in the arrow of the column, the sort it isn't correct, and the bigger numbers are considerate as strings. 

Can you guys help me solve this please ?

Tell me if you need more things 

[isoutamo]

Hi

you should look

• fieldformat
• tostring(var,”commas”)

which fulfills your requirement.

r. Ismo

[alvesri]

Hi thank you for the reply,

I tried that, and it works replacing the comma with a space, but the issue it's next when i click on the column to sort in a descending order, and the numbers are not sorted correctly, because some of them are string and others are numbers, and I tried the conversion "tonumber()" 

[isoutamo]

Fieldformat is just to keep those values as numbers instead of covert those to string as happened with eval.

[ITWhisperer · Accepted solution]

| fieldformat value=replace(tostring(value,"commas"),","," ")

[alvesri]

Hi guys,

I did this ant it worked in replacing the comma, thank you. 
The N/A is in case i'ts empty.

| eval value= if(value!="N/A", replace(tostring(value,"commas"),","," "),value)

But the thing is, I can't order it correctly.