Forum Discussion
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...
Oh, I guess I misunderstood. Then replace "," with "." instead of blank.
100,00 should be 100 and 99,85 should be 99,85 and not 9985 for example. The commas disappear at all
Oh, I guess I misunderstood. Then replace "," with "." instead of blank.
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
This one comment saved my life today. Thanks man!
