Home > database >  The computational domain problem, why quantity * unit price to retain two decimal places with the fi
The computational domain problem, why quantity * unit price to retain two decimal places with the fi

Time:10-07

Two column in data window, tax_price in_amount quantity and the unit price and amount in computational domain round (tax_price * in_amount, 2)
Number input unit price 2.3 14.45 the results of calculation domain is 33.23, the actual should be 33.235 round should be 33.24.
Then verify other data input can achieve rounded right, is that the data is not correct, if separate use round (32.235, 2)
33.24 correctlyI don't know why? To solve the

CodePudding user response:

In_amount quantity and unit price tax_price data type is what? Try to delete calculation domain reconstruction

CodePudding user response:

You in_amount tax_price types in dec

CodePudding user response:

Assure accuracy as calculated again

CodePudding user response:

Variable data types
  • Related