Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Convert text with commas into value

Hi all,   My database has some numerical fields that come in text and some of them have commas, by the time to convert the text to a value, the comma disappear and my number become  "bigger". For e...
Need Help
  • Chihiro's avatar
    Chihiro
    7 years ago

    Oh, I guess I misunderstood. Then replace "," with "." instead of blank.

Chihiro's avatar
Chihiro
Solution Sage
7 years ago

Oh, I guess I misunderstood. Then replace "," with "." instead of blank.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I've used several formulas to reach my final goal, and I was successfull, thank you guys 

 

Test = VALUE(if(find(",";Production[PRODUCTION EBITDA YTD];1;0)>0;replace(Production[PRODUCTION EBITDA YTD];find(",";Production[PRODUCTION EBITDA YTD];1;0);1;".");Production[PRODUCTION EBITDA YTD]))

 

Best regards