Alteryx designer Discussions

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

Format negative amount

Highlighted
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. 

 

thanks

Jana

Highlighted
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.

AbhilashR_0-1589940618767.png

Let us know if you run into other issues.

 

Labels