community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Change figures to currency

Meteor

I want to change figures in certain columns to currency format rather than decimal. 

 

So example

 

F1         F2              F3          F4

HE        203.2223   0.1         999.9919192492

 

So above change all rows in F1,F2 and F3 to currency? 

Highlighted
Alteryx Certified Partner

Hi @JamesG2806 

 

Use Multi-Field Formula Tool with all your double fields.

 

'$'+ToString([FieldName], 2, 1)

 

This topic clarifies everything you need to know about Currency Conversion.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Everything-You-Need-to-Know-About-Currency/t...

 

 

Cheers,

Alteryx Certified Partner

Hi @JamesG2806 

 

A multi-field formula setup similar to the below should do the trick

 

Screenshot 2019-05-14 at 19.19.30.png

Magnetar

Hi @JamesG2806 

 

Both of the answers provided by the Tag Team of @Thableaus and @jamielaird are great, but they do convert the fields to strings, which means that you won't be able to perform further calculations on these fields without stripping off the "$" and converting the result back to number.  So make sure you perform these steps after all your calculations have been done

 

Dan

Labels