Formula Data studio convert text into number

Imefungwa Ilichapishwa Miaka 2 iliyopita Kulipwa wakati wa kujifungua
Imefungwa Kulipwa wakati wa kujifungua

In Google Data Studio, I would like to find the formula for a new calculated field to transform a number recognized as text into a number recognized as a number: example € 1,010.00 (text) => 1010.00 (number)

Currently I use the formula

cast (trim (replace (REPLACE (replace (Rate J text, '', ''), '€', ''), ',', '.')) as number) but it doesn't work.

I come to my end by creating an additional column on google sheet with the following formula = TRIM (SUBSTITUTE (BO5; CHAR (160); "")) * 1

The goal is to achieve the desired result by creating a field calculated on Data studio only.

Are you capable of meeting this challenge.

Uingizaji Data Kutengeneza Data Google Sheets Data Science Google Analytics

Kitambulisho cha Mradi: #29845683

Kuhusu mradi

8 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

8 wafanyakazi huru wanazabuni wastani wa €27 kwa kazi hii

schoudhary1553

Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 660 + Projects. I have 6 + years of the experience in sam Zaidi

€100 EUR kwa siku 2
(Maoni 314)
8.1
hdlong66

Hello, My formula allows to convert text to number format. I can share it with you immediately. Please drop a PM if you’re interested. Best regards, Hoang

€8 EUR kwa siku 1
(Maoni 149)
6.9
najmulhosaon08

Hey, I would be happy to work on your job immediately. If you want fast accurate and timely delivery to your task just ping me. I am here and ready to help you. Send me a quick message and we can figure out if we are Zaidi

€19 EUR kwa siku 2
(Maoni 1)
0.0
yesminsathi762

hi dear; sir/mam i agree your proposal i am a full time freelancer ,i will try my best to service represent to you. please hand over your project

€19 EUR kwa siku 7
(Maoni 0)
0.0
ichalpenjas

hi, I have read your proposed job, and I am more than happy to take the job you want. I'll do it really fast. thank you

€24 EUR kwa siku 3
(Maoni 0)
0.0
pjs1689

Sir, I have a simple formula to transform a number recognized as text into a number recognized as a number you given € 1,010.00 (text) => 1010.00 (number). Assign me I will provide it ( I having it in excel), I am als Zaidi

€8 EUR kwa siku 1
(Maoni 0)
0.0