I have a gsheet input with a mix of negatives in parenthesis and using minus sign.
I put this field through a Select tool and change the data type to double, but the 2.50 and 2 turn to NULL.
Best way around this so the negatives are recognized?
The input is many columns, does Alteryx really not have a way to treat both (100) and -100 as negative numbers from inputs?
thanks
It's not that it doesn't have a way it is that those are different ways to represent a negative number and you want to standardize them. The replace function above is easy to do this. If you need to adjust many different columns at once you can use the multi-field formula tool.