My Percentages show to many Zeros. Why?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a SQL Linked table for which I can not change any datatypes etc. It is
set to a Number DataType. When I select Percentages and 1 decimal. It does
not show the correct results. Example: I want it to look like this -49.9%.
The results show
-4999.0%. Can someone help me with this. I feel I tried everything? Thanks
again
 
Percent is a fraction. If you have computed it as 49.6% it is stored as a
number, not as a percent. And then when you tell it to format it as a
percent it multiples by 100 and includes the percent sign.
 
Back
Top