Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to convert the following Strings to Numbers:
I also want to remove the decimal place after the "," (It is always 000)
For the thousands separator, i want to show a comma instead of the "."
Example: Current String: 80.000,000 --> Expected Number: 80,000
Example 2: Current String: 200,000 --> Expected Number: 200
As I tried to understand, the right way to do this is something like that in the loading script :
Num#(CURRENTMAX,'#.#', ',', '.') as NEUMAX
I understood that the '#' operator denotes a possible digit to the left of the decimal point.
What is the right format code to get things working?
Thanks in advance! 😊
You can adjust with the num function, but note that this is a mask:
=num(num#(CURRENTMAX, '#.## 0,000', ',', '.'), '#,##0')
You can also round off the number to make the decimal places disappear:
=floor(num#(CURRENTMAX, '#.##0,000', ',', '.'))
After this you apply num function
Hi
If you are sure that your input is going to be in the format shown you could try the following
Replace(Replace(CURRENTMAX,',000',''),'.',',') ) as NEUMAX
Regards
Adrian
You can adjust with the num function, but note that this is a mask:
=num(num#(CURRENTMAX, '#.## 0,000', ',', '.'), '#,##0')
You can also round off the number to make the decimal places disappear:
=floor(num#(CURRENTMAX, '#.##0,000', ',', '.'))
After this you apply num function