Yuri,
thank you for reply.
In real life, price and quantity fields contain any values up to 6 digits after comma.
I need to round the RESULT of multiplication to two digits.
I cannot round the operands because in this case the result may be incorrect if operands have 6 digits after comma !
How to implement the rounding in this case ?
>OK, I see the problem. It occurs when the sum of the decimals to round exceed 12. Perhaps you my use:
>
>?ROUND( round(t1.price,5)*t2.quantity,2)
>
>
>
>>>The product is 25.425. Why do you expect 25.43? It should be 25.42.
>>
>>Because, when you round 24.425 to two decimals, you get 24.43 (since the first digit dropped is a 5, VFP rounds up). Try it with the ROUND() function.
>>
>>Hilmar.
Andrus