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.
Bu iş için 8 freelancer ortalamada €27 teklif veriyor
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
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
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 Daha Fazla
I have read your requirements regarding converting text to number by creating new field in Digital studio fields data and I can assure that I will deliver your project on time with good accuracy. Please see below the s Daha Fazla