In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to display thousand separator in type of "Double"

takusan
5 - Atom

Although I selected ",(Comm)" in "Thousand Separator" of "Localization Settings", value of Double in my canvas isn't adapted "Thousand Separator". If I should do other settings, let me know how to set.

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

@takusan ,

 

doubles allow for the character set of 0-9 and your local decimal character (e.g. comma or period). 

Double data tours do not include thousands separators. 

If you want to see the separator, you need to convert to a string. 

cheers,

 

 mail

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
takusan
5 - Atom

Thank you for your answer.

I would like to display amount of JPY. JPY doesn't have decimal point. What do you think which data type in this case? 

MarqueeCrew
20 - Arcturus
20 - Arcturus

any string data type will work

 

 cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels
Top Solution Authors