Convert String to Double for Amount

Sheena_Mae

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?

Thank you.

grazitti_sapna

@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!!

New Workflow18.yxmd