Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Format negative amount

JanaZ
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

1 REPLY 1
AbhilashR
15 - Aurora
15 - Aurora

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