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.
Solved! Go to Solution.
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.