Convert TEXT to NUMBER

1

Hello BaseUsers!
I want a help about my Baserow self-hosted:

I need convert text to number data, BUT the conversion does not be efficiently.

Comma not be converted to decimal numbers, follow the imagem below

image
image634×660 33.4 KB

2

Hekki @eldertheodoro, try this:

tonumber(replace(field('VALOR_VENDA'), ',', '.'))

3

Thanks Olga for your help!

1 Like