in my report i have columns like
eg:
type of income YTDNS Amounts Percentage
a 12
b 11
c 8
when i tried to to change this data into percentage using data format my result like this
a 1200%
b 1100%
c 800%
i also removed decimal palces.and made all data format.but i didnt get correct output.please help me? :(
Don't know what's your requirement though, if you just want to see like 12%, 11%, 8%.. Unlock your report, drag a text item and drop beside your measure cell. Double Click the Text Item and define '%' ;)
should do? ;D
Thanks
Prit
hi Prit,
i did the same thing to satsfy my client. but i want to know why its showing like that.
thanks
krishna
Off course it would show like that, if you are just showing a number as percentage, then it would multiply with 100.
When formatting as percentages look at the scale property setting!!
You could add a data item to your query and call it something like "Percentage of Column X" then define it as:
[Query X].[Column X] / 100
You will then be able to apply a Percentage data type to it. Hope that made sense.
Juast do as Bloom said.... check the scale in format properties.
VALUE of 1 scale 0 = 100%
1 scale -1 = 10%
1 scale -2 = 1%
It's more easy to do that and have te real value instead of transforming the value to get purcentage.
Regards