The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
4 years ago

Dashboard - How to format numbers within SQL table editor?

Hello, 

So we loaded some data to an application database, which we are accessing within Dashboard. Does anyone know how to format the table values in general? For e.g. I want the decimal to show in pct.

 

I tried to format numbers within here - but couldn't make it work. Am I missing something? Please suggest


Thank you! 

 

dashboards

4 Replies

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    4 years ago

    Hi Mustafa_A: you can generally use the same formatting strings as what is used in Cube Views.  Full navigation instructions: use the ellipse for the column you want to format.  The setting you want is under General > DataFormatString.  Use the ellipse again to bring up the object lookup.  Navigate to Number Formats and make a selection.

    Cheers,  -DB

    • Mustafa_A's avatar
      Mustafa_A
      Contributor II
      4 years ago

      Thank you! db_pdx  ChristianW 

      I learned something new! That P0-P6 is a recognized formatting syntax in OS.

       

      Looks good now - 

       

       

  • ChristianW's avatar
    ChristianW
    Icon for OneStream Employee rankOneStream Employee
    4 years ago

    The easiest formats are n0 to n6 for 0 to 6 decimals and p0 to p6 for percentages.

    • IBK's avatar
      IBK
      New Contributor III
      2 years ago

      Hello Christian,

      Is there a way to format the numbers to show Red on being negative in the Sql Table Editor?

       

      Thank You,

      Indu