Decimal Places

[SteveF]

Another dumb question; sorry

I'm running a report which produces a percentage. When I do the calculation myself it comes out at 60.81%, when I run it in Access it comes out at 601.81%, any idea where I'm going wrong?

Thanks in advance.

 

[raskew]

Show us an example of your report's code and/or the underlying query.
Bob

 

[SteveF]

Sorry to take so long coming back, been working today and not had chance to sit down to this. I do appreciate help.

This is the calculation:

=Sum([SumOfGP Amount]/[SumOfCons Ex VAT])

My ignorance runs pretty deep, so 'scuse if I get any terminology wrong. But the two amounts I want to use in the calculation are at the bottom of columns of other numbers as totals.

 

[Alisa]

If you want percent, don't you have to divide by 100?

 

[SteveF]

If I'm working out percentages on a calculator then I have to multiply by 100 to move the decimal point across, but spreadsheets and databases seem to know where to put the decimal when you use percentage as the number format.

I sorted this out myself, it was a simple case of missing brackets but it took me a while to figure it out

 

[Alisa]

ok, glad to hear it worked out.