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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only