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: I'd like to change this view to show it like it is but without decimal places. Unfortunatelly when I try to change...
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

Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi bartosz_s,

 

Did you try the round function?

 

If not give sample data with expected results.

 

Ninter

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

    • bartosz_s's avatar
      bartosz_s
      Regular Visitor
      8 years ago

      Thank you :)