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!
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
Thank you! db_pdx ChristianW
I learned something new! That P0-P6 is a recognized formatting syntax in OS.
Looks good now -
The easiest formats are n0 to n6 for 0 to 6 decimals and p0 to p6 for percentages.
Hello Christian,
Is there a way to format the numbers to show Red on being negative in the Sql Table Editor?
Thank You,
Indu
