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 |
