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 |
@birdjrk what is the logic for calculating the Sum_Oil Sold (BBls)