Forum Discussion

bartosz_s's avatar
bartosz_s
Regular Visitor
8 years ago
Solved

number formating issue

Hi to All,

I have a figure with decimal places which is displayed like this:
Before

I'd like to change this view to show it like it is but without decimal places. Unfortunatelly when I try to change Format and set decimal places to "0" thousand separator disapears. and have a figure:

Thank you,

B.

Need Help
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    hi bartosz_s,

     

    Then try this formula to create a calculated column ( my table is called Table1 and field Column1):

    Column = FORMAT(Table1[Column1],"### ### ##0")

    Hope it helps...

     

    Ninter

4 Replies

    • bartosz_s's avatar
      bartosz_s
      Regular Visitor
      8 years ago

      Hi,

      unfortunately it doesn't work. ROUND function is not chanhing the way how the numbers are displayed (expected format is xxx yyy zzz. Example 123 456 789). I still have xxxyyyzzz.

      Example:

      Number: 123 456 789,89 is displayed 123456790 not 123 456 790.

      • Interkoubess's avatar
        Interkoubess
        Solution Sage
        8 years ago

        hi bartosz_s,

         

        Then try this formula to create a calculated column ( my table is called Table1 and field Column1):

        Column = FORMAT(Table1[Column1],"### ### ##0")

        Hope it helps...

         

        Ninter