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

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