Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Format negative amount

7 - Meteor

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. 




Alteryx Certified Partner

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.