Percentage

[Chi]

Hi,
In my report that has TOTAL1 and TOTAL2 fields.

To calculate a percentage, I divided TOTAL1/TOTAL2 and the result looks ok.
However, when I formatted it to percentage, it seems wrong.

Ex: ToTal1 Total 2
32 1 = 32. After formatting to percentage, it
became 3200%. Do you think it is right?

Please help
Thanks
Chi Huynh

 

[RBear3]

Yes, 32/1 does equal the whole number 32. The whole number 32 is 3200%

to get 32%, you would need the number 0.32.

If you want that, change your formula to...

=([TOTAL1] / [TOTAL2]) /100

 

[Chi]

Thank you so much.
Chi Huynh

Yes, 32/1 does equal the whole number 32. The whole number 32 is 3200%

to get 32%, you would need the number 0.32.

If you want that, change your formula to...

=([TOTAL1] / [TOTAL2]) /100



--
Hope that helps!

RBear3
..

Hi,
In my report that has TOTAL1 and TOTAL2 fields.

To calculate a percentage, I divided TOTAL1/TOTAL2 and the result looks
ok.
However, when I formatted it to percentage, it seems wrong.

Ex: ToTal1 Total 2
32 1 = 32. After formatting to percentage, it
became 3200%. Do you think it is right?

Please help
Thanks
Chi Huynh