Convert the number with comma and decimal without it

[jkorattiyil]

Hello - Can someone please help me to know is there a way in Alteryx to convert the numbers such as 100.25 or 250.50 to 10025 and 25050. I tried Regex formfula but it nor giving me teh desired result.

[TheOC]

hey @jkorattiyil 
Please find attached:

I did it in a single formula. Effectively convert the number to a string, remove the ".", and then convert it back to a number.
Hope this helps,
TheOC

[binu_acs]

@jkorattiyil 

toNumber(Replace( ToString([Numbers]),'.',''))

[jkorattiyil]

Thank you so much!, it worked...