Forum Discussion
Create a table with mixed format values
Hi Folks, I have to create a new table (Below the example) showing different KPI's and some of them are a percentage format and some others are a regular decimal number format. In the DB we have the ...
Hi, thanks for your suggestion, but I'm a little lost following your step 2. How can I go to the query editor if the new table was created outside the Query Editor?
Thank in advance!
It's not possible to configure dynamic format for a single column. And if you create a calculated column with FORMAT(), the data type will be text. For your requirement, it can't be achieved unless you unpoivt KPI2 into a column as samdthompson suggested.
Regards,