Number Output Incorrect

[jrkmorgan]

I resolved my issue here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/LOS-Statements-Converting-0-00-and-0-0...

I then added a select tool and have everything set as double - then to output.

My output is giving me horrible values, see table below - the actual value is what it should be.

Where did I go wrong here? I can't find anywhere in my workflow I've got anything other than the original v_string - multi field formula to replace $ . , ( ) and then select to double.

Alteryx formula logic is new to me - I can do this in Excel & Access all day long.

Sum_Oil Sold (BBls)	ACTUAL VALUE
111,856.00	111,856.00
4,812.00	4,812.00
49,915,000,000,000,000.00	49,915.00
32,149.00	32,149.00
18,780,000,000,000,000.00	18,780.00
35,125,000,000,000,000.00	3,512,500.00
350,838.00	350,838.00
344,589.00	344,589.00
96,109,000,000,000,000.00	961,090.00
48,937.00	48,937.00
10,459.00	10,459.00
1,103.00	1,103.00
575.00	575.00
71,576.00	71,576.00

[binu_acs]

@jrkmorgan what is the logic for calculating the Sum_Oil Sold (BBls)