Negative numbers converting to null

[Usamah22]

hello,

i have a column with numbers which is currently a string. when i convert it to a double to do calculations the negative values (as below) are being lost and set as null. how can i resolve this?

[pedrodrfaria · Accepted solution]

Hi @Usamah22 

This function using the formula tool before changing the data type will fix the error for you.

If you only have negative values:

Replace(Replace([Field], "(" ,"-"), ")", "")

If you have positive as well, you can do something like this:

if contains([Field], "(" ) then

Replace(Replace([Field], "(" ,"-"), ")", "") else

[Field] endif

Pedro

[Qiu]

@Usamah22 
Maybe we can do like this.