Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Converting US/English Numbers to the Continental Eurpoean Standard

Alteryx Alumni (Retired)

Alteryx defaults to using the US/English Standard when it comes to number formats. However, for reporting purposes, it is important to remember that not all countries report their numbers in the same fashion. This article shows a quick and easy way to use Raw PCXML to convert numbers in to the Continental European Standard before outputting a final report.

Throughout the workflow building process, numbers will be represented in the US/English Standard of 1,000.00.  However, when building an automated report, it is important to remember who the audience will be. In the case of users in countries that use the Continental European Standard, it may best to have Alteryx change the numerical formatting system before outputting the final report. The following example is specific for the Spanish-Spain numbering convention.



1. Pass the data through a Table tool to create a Table Report Snippet.

2. Insert a Report Text Tool and format as seen below. The LocaleID is what is specifically driving the formatting change.  For more information on other locale ID's check out this article.

2016-03-28 14_01_31-Conversations.png
3. Complete your layout and use a Render tool to complete your automated report.

Please see the attached workflow for an example in practice.

No ratings