how to can i convert a value into percentage?

[bvk.cognoise]

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? :(

[PRIT AMRIT]

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

[bvk.cognoise]

hi Prit,

i did the same thing to satsfy my client. but i want to know why its showing like that.

thanks
krishna

[PRIT AMRIT]

Off course it would show like that, if you are just showing a number as percentage, then it would multiply with 100.

[blom0344]

When formatting as percentages look at the scale property setting!!

[holografix]

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.

[jive]

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