05-19-2022 05:21 PM - last edited on 05-24-2023 04:35 AM by JackLacava
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!
05-19-2022 08:18 PM
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
05-20-2022 12:17 PM - edited 05-20-2022 12:19 PM
Thank you! @db_pdx @ChristianW
I learned something new! That P0-P6 is a recognized formatting syntax in OS.
Looks good now -
05-20-2022 02:16 AM
The easiest formats are n0 to n6 for 0 to 6 decimals and p0 to p6 for percentages.
03-26-2024 06:19 PM
Hello Christian,
Is there a way to format the numbers to show Red on being negative in the Sql Table Editor?
Thank You,
Indu