HI,

On Thread #842819 a ROUND() problem is discussed.

No, i start by a simple two fields values, and want compute the sum of they product;
the standard precision is set to 11.

SET DECIMALS TO 11
SET FIXED ON
CREATE CURSOR orderRows (quantity N(10,1),weight N(9,2))
INSERT INTO orderRows VALUES (3.9,55.15)

CALCULATE SUM(quantity*weight) TO calcTotalWeight
? ROUND(calcTotalWeight,2)
SELECT SUM(quantity*weight) totalweight FROM orderRows INTO ARRAY selTotalWeight
? ROUND(selTotalWeight,2)

? 'NO ROUND  : ', calcTotalWeight,selTotalWeight,IIF(calcTotalWeight=selTotalWeight,' EQUAL',' NOT EQUAL')

FOR k=14 TO 1 STEP -1
 ? TRANS(m.k,'@R ROUND  99  : '), ROUND(calcTotalWeight,m.k),ROUND(selTotalWeight,m.k),IIF(ROUND(calcTotalWeight,m.k)=ROUND(selTotalWeight,m.k),' EQUAL',' NOT EQUAL')
next

? (calcTotalWeight-selTotalWeight)*1024*1024*1024*1024*1024 && binary shift the difference 

I put two questions ( i known the answer ):
First problem:
Why CALCULATE and SELECT return two different values ?

Seconds problem:
Why ROUND(,2) of the results are different ?

I put another question ( i donnot known the answer ):
I can use VFP for do computations and to trust me of the results?

If for any use of VFP language i need do complete analysis of all the process of calculation, I have lost all the advantage to use a top level language.

Thanks

Fabio