Percentages in Reports - Before I go mad!!!

[theconfusedbear]

This is driving me crazy, with my muppet knowledge!

I have a report which has the following fields

Application Count
Hit And Miss Count
Sale Count

I am trying to do a percentage from

Hit and Miss Count plus Sale Count / Application Count

I put it in an expression on the report but it shows complete rubbish

=sum([Hit and Miss count]+[Sale count])/Application count

I set the field to be a percentage but its coming up with 10000% on a 4 - 4 score - this should be 100%

Please help me! I have gone through all the help pages and im getting nowhere fast!

Thank you

 

[Rickster57]

percent

Take the easy way out and divide the whole expression by 100

 

[Moniker]

Rickster's solution will work, as will this:

=Format(sum([Hit and Miss count]+[Sale count])/Application count ,Percentage)

 

[theconfusedbear]

thank you ....