Number format issues

[ManuelRodrigues]

Hi All

I need to put the format of the number in the Cumulative to dat column in a recognizable number that can work with the workflow (i.e. remove the , and . )

Thanks!

[IraWatt]

Hey @ManuelRodrigues,

You can use the replace formula to replace the dots and commas to an empty string:

Replace( Replace([Field1], ",", ""),".","")

Then use a select to convert the text to a number:

The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[binuacs]

@ManuelRodrigues Check your settings

[Felipe_Ribeir0]

Hi @ManuelRodrigues 

Try this formula

ToNumber(Replace(Replace([Cumulative to Date], '.', ''), ',', '.'), 2)