How to calculate a percentage of two fields and format properly

[mdnikki]

For the life of me, I know I have done this before but for some reason the formatting looks terrible.

I am doing this in a report obviously. I have two fields CountOFAppeal Description and Amount Solicited.

I just want to get the percentage of response.



So this is what I used:

=[CountOfAppeal Description]/[Amount Solicited]*100

When I go into the properties to format it to % and add decimal places I get a crazy number
2520.46% When it should be 25.20%

When I change the format to general number the decimal point is in the right place 25.20.

Any help is appreciated.

[ketbdnetbp]

mdnikki -

When the percent format is applied, it multiplies the value by 100 and then appends the percent sign. So, in your case...

=[CountOfAppeal Description]/[Amount Solicited]*100 , you have already made that calculation. Changing the format to % will duplicate the multiplication.

Therefore, change this:
=[CountOfAppeal Description]/[Amount Solicited]*100
to:
=[CountOfAppeal Description]/[Amount Solicited] and then apply the % format.

Hope this helps,

Jim

[mdnikki]

Perfect....that did it.. Thanks!