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

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Currency formula, or adding the comma separator

Community Content Engineer
Community Content Engineer
Created on

If you're using the Formula Tool in v11.0+, be sure to familiarize yourself with the tool's interface redesign!

 

Often, clients try to format a plain numeric value to a currency format. A simple way to accomplish this is to use the optional "addCommas" parameter in the ToString function. This function converts a numeric value to a string, using a user-specified number of decimal places [numDec]. Though Alteryx doesn’t require the third parameter, if called, the third parameter inserts the appropriate commas (1 or true means format with commas).

 

ToString([original_value], 2, 1)

 

Since the new value is a String, simply add in the dollar symbol:

 

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

 

currency formula results.JPG

 

Happy Alteryx-ing!