Wierd error in calculation in a report!!

[smile82]

Hi people,
Thanks for looking into my question!
I am trying to execute a calculation in a report like:
Sum([CountOfDATE])/Reports![ReportA]![txtbox]
This calculation seems to work fine with all values except for those whose answer is in 100th decimal place.
meaning:
If Sum([CountOfDATE])=2
and If Reports![ReportA]![txtbox] = 76
The Answer should be 2/76=0.02631 but IT SHOWS the answer as 2.631
If Sum([CountOfDATE])=20
and If Reports![ReportA]![txtbox] = 76
The answer it shows is right ie 20/76 = 0.263
So the error occurs for answers which look like 0.0xxx and it shows it as x.xxx
Could anybody pls help?
Thanks!

 

[mp9]

Check the Format property of the field displaying this calculation - its sounds like it is set to Percent. Set it back to General Number.

http://www22.brinkster.com/accessory/