Blackwidow
Registered User.
- Local time
- Today, 18:23
- Joined
- Apr 30, 2003
- Messages
- 149
I have a field on my report
=Sum([Achieved])/Count([Surname])*100 & "%"
with decimal place at 2 and format at Percent.
This works fine except that it doesnt round to 2 and instead gives the percentage like 46.666666666667%
I tried to run it without % added at the end of the formula but it gives me a percentage of 4666.67%..
Have I done something wrong? Obviously I have I just cant see it
=Sum([Achieved])/Count([Surname])*100 & "%"
with decimal place at 2 and format at Percent.
This works fine except that it doesnt round to 2 and instead gives the percentage like 46.666666666667%
I tried to run it without % added at the end of the formula but it gives me a percentage of 4666.67%..
Have I done something wrong? Obviously I have I just cant see it