VString to Double with Commas

[kubikbr]

Looking for some help on the issue below. Data source export is in the first column, which contains numbers with commas and is coming into Alteryx as VString. Normally, I just use the select tool and change to double or a number. In this instance, Alteryx is taking the first two numbers before the comma and dropping the rest. 

Do i have to just find replace the comma to fix? or is there an alternative solution? thanks

Source	Alteryx Workflow
vstring	double
Pmt Amt	Pmt Amt
25,500.00	25
108.33	108.33
26,350.00	26
26,350.00	26
24,650.00	24
108.33	108.33
80	80

[AGilbert]

try the tonumber() function. 

[kubikbr]

this approach is unable to convert any negative numbers in the dataset, looks like those are just bring treated as 0.

workbook attached with full dataset 

[binuacs]

@kubikbr you need to remove the ',' from the amount field to convert it into double

[kubikbr]

binuacs - this approach is still converting negative numbers in the large dataset to 0, which is overstating the column total. 

[AGilbert]

Looks like your negative numbers are formatted with parenthesis. Use the replace and tonumber functions below. Example attached. 

[binuacs · Accepted solution]

@kubikbr As @AGilbert mentioned if you have brackets for negative numbers you need to replace them

toNumber(ReplaceChar([Pmt Amt], ',()', ''))

[kubikbr]

thank you both for your help on this