Dashboard - How to format numbers within SQL table editor?

[Mustafa_A]

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! 

[db_pdx]

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]

Thank you! @db_pdx  @ChristianW 

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

Looks good now - 

[ChristianW]

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

[IBK]

Hello Christian,

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

Thank You,

Indu