Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to Format Currency?

harrynguyen2000
5 - Atom

I have the Price column (V_String) with different currency formats as below. I want to add decimals and make them all the same (i.e: $1234.00). 

 

I tried ToString([Price],2,1) and also IF Contains([Price], ".") THEN [Price] ELSE ([Price] + ".00") ENDIF but they did nothing. 

 

Does anyone know how to do this? Thank you in advance!

harrynguyen2000_0-1632860809979.png

 

 

3 REPLIES 3
dougperez
11 - Bolide

Hello!

See the workflow attached.

vsoni
Alteryx
Alteryx

this should do the trick

sparksun
8 - Asteroid

Slightly change your expression to the following will do the trick.

 IF Contains([Price], ".")=-1 THEN [Price] ELSE ([Price] + ".00")

Labels