Enter Numbers In $Format

MKanchwa

I have prepared a workflow which gives me output as numbers with decimals but I want the numbers in $ format without decimals and thousand separator. Attached is an example of the desired output. The output should be a number & not a String.

Please Help.

JosephSerpis

Hi @MKanchwa you can format your data as you describe in your output with this synatx "$"+ToString([Field], 0,1) which will round your decimal places and add in separators. However the field will be a string it's not add in the dollar sign in the field and keep the field as a numeric field. 

The Link below describes everything you need to know about working with currencies and Alteryx.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Everything-You-Need-to-Know-About-Currency/ta-p/26332