Forum Discussion
Helper IThousand Separtors
Hi Arun,
For me it defaults to the US version when I select the field and select comma in modeling. If your default is diferent, you could perhaps force it using Format command such as
newdata = FORMAT(data[Column1],"#,0.")
You are welcome. Glad it worked for you.
Helper IHi,
The idea you suggested is working but it creates another problem. When using the format function the number is converted into text. When i tried value(Format([col]),"#,0") then the thousand separator disapper. Something found but not the output as expected.
Buzz me if you have any idea.
Thanks in advance.
Hi Arun,
when I used the value function to cast the text as a number, it did keep the commas but added decimal places.
newdata = value(FORMAT(data[Column1],"#,0."))I also changed the original column to a text field and the 'newdata' still came out formatted correctly ( but with decimals).- ArunkumarK
I assume my words make you confused. Even I get the answer same what you got but when you sum the column values it wont come because of it converted into text.
E.g If a column have multiple rows with data and we formated in such a way then in the report section if you try to sum, it wont allow except count.
Hope make sense.
Yes, you are right, I am not quite following. I am getting commas correctly when displaying the numbers individually or as a sum (see image). I added a few more rows and then showing a sum in a cardfile. Sorry, I am not sure how to help you further since I am getting the correct data (as I understand it).