Numbers in parenthesis turn to null after select data type change to double

[Carluccio555]

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?

[TimN]

Hi,

You can replace the ().  See if the attached helps.

[binuacs]

@Carluccio555 One way of doing this

[Carluccio555]

The input is many columns, does Alteryx really not have a way to treat both (100) and -100 as negative numbers from inputs?

thanks

[JoshuaB]

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.