Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tinamiller1
Yak Posting Veteran
78 Posts |
 Posted - 2014-12-29 : 17:44:48
|
| I am using SQL Server and have a table that is currently set to decimal(5,2) as the datatype. I am using Tableau as my front-end and if I create a dashboard, I can see my fields like 65.25, 65.72, etc. I want to view them as 65.25% however when I change the data type in Tableau to a %, it shows up as 6525.25%. Is there a way in the SQL Server side to change the column so it shows as a percent? I am sure the answer is no because I have never seen that. Only seen decimal values. Maybe I need to change it to decimal 2.2 if that even exists.tina m miller |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-12-29 : 17:46:38
|
| You would have to change it to varchar to do this in SQL Server, but you need to figure out what's wrong in Tableau as that's where the issue is.Decimal 5,2 is the proper data type for this.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-12-29 : 23:38:28
|
When you calculate the percentage value, don't multiply by 100.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
tinamiller1
Yak Posting Veteran
78 Posts |
Posted - 2014-12-30 : 08:22:42
|
| Yes I thought 5,2 was the proper. I do believe it is something on Tableau side. I will have to see if there is a way to fix it through the Tableau folks. Thanks.tina m miller |
|
|
|
|
|
|
SQL Server Column as Percent