Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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