We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Convert String to Double for Amount

Sheena_Mae
6 - Meteoroid

Hi!

I am new to Alteryx. I hope you can help me.

I have a field string for my amount "3,359.83-" , is it possible to convert this to "-3359.83" and make the field to double ?

or is it just "3359.83-" and make the field to double? Does Summing it up doesn't affect the total value?

 

 

Sheena_Mae_0-1662617554620.png

 

Thank you.

 

 

2 REPLIES 2
grazitti_sapna
17 - Castor

@Sheena_Mae , You can achieve this by using formula tool and select tool. Please take a look at the workflow I shared and accept my solution if it helps.

Thanks!!

Sapna Gupta
Sheena_Mae
6 - Meteoroid

@grazitti_sapna   

Thank you very much! You're a big help.

Cheers to solving!

 

 

:D

Labels
Top Solution Authors