Format negative amount

[JanaZ]

Hi there,

I would like to add a formula for column E (Amount) to calculate GST. 

I have tried to change it to Double, but as it is negative value, it become Null. 

Could someone please help?

I have attached the sample. 

thanks

Jana

[AbhilashR · Accepted solution]

Hi @JanaZ, Alteryx doesn't like comma's in the data when you are attempting to convert the column from string to numeric datatype. So as an approach you need to remove commas and convert the datatype to double. I have used the Multi-Field formula tool to remove comma and change datatype at one go, but you could achieve the same using a combination of Formula + Select tools.

Let us know if you run into other issues.