Forum Discussion

ArunkumarK's avatar
ArunkumarK
Icon for Helper I rankHelper I
7 years ago
Solved

Thousand Separtors

Hello Everyone, I needs to convert the number into US thousand separtors like below. How to conver the number into highlighed formats like below.   Available Number: 125000 Available Format: 1,25...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.")
     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I understand the 2nd issue now. Using the value function causes the Sigma sign next to the column to disappear, even though it is technically a number.  As I understand it, only columns with that sign will show totals within a table or matrix.  You can still show sums at a row level within the table or in cards, but it will not show total within the table. You may want to pose that as another question in the community and see if anyone else has ideas on showing totals in a table when using Value.   

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Arun,

ok, I got this to work just by adding a new column that was a mirror of the newdata column I had created.  Essentially I created a new calculated column: 

newdata2 = data[newdata]
 
Here is the image of it working with a table total: