Adding thousand separator while keeping the field as numeric

Hello community,

I have a dataset and in my output I want to see the thousand separators while keeping them numeric. In Alteryx, I was able to get the thousand separator through making it to a string but when I tried to convert it back to Numeric then I get conversion errors. Is there any way to do it?

Thanks a lot!!

Workflow

Accepted answers

danilang

Hi @binnursev

The option that @L_T mentioned is only available in newer versions of Alteryx. Since you seems to be on an older version, there's no way to have the thousands separator without converting the entire column to String. What's your final goal? Why do you need the separators?

Dan

All comments

L_T

Hi @binnursev,

Please see below where you can change settings - if your field is numeric, the button in the bottom right corner should work.

binnursev

Thanks a lot for your response. When I go to User Settings, I don't get the option to change the Number settings. Is there another way, like a formula to use?

Best regards

Binnur

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703