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