CALCULATE STD(MyField) gives wrong result

[papadopo]

Hello everybody,

I use VFP 7

I have a table MyTable.DBF with a field MyField N(15,4) with values

23334.9000
23334.9000
23334.9000

I go:

SET DECIMALS TO 4

SELECT MyTable
CALCULATE STD(MyField) TO X

VFP gives as result x = *******************

instead of 0

the really weird thing is that when i change the values to

23334.9100
23334.9100
23334.9100

I get the correct result

Another thing is that if i go

SET DECIMALS TO 2

the STD works fine with these specific values (23334.9000)

Have you heard of anything about this sort of thing? Is this a bug?

I really need to understand what other case there might be that give wrong results, and what if

SET DECIMALS TO 2

gives wrong results to some other values

thanks alot

papadopo

----------
"Never Send a Human to do a Machine's Job"

 

[Mike Lewis]

Hi papadopo,

Am I mistaken, or is the same question that you posted in thread184-859053? If so, I think there were several useful answers there.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com