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 :)