I have the following SELECT that is giving me the wrong result. The
statement is shown below.
SELECT (dbo.tblArHistHeader.Rep1CommRate / 100) *
dbo.tblArHistDetail.PriceExt AS CommRep1
Both columns are Decimal(20,10) type. An example is when PriceExt =
450.0000000000 and Rep1CommRate is 8.0000000000 then the result is
67.50000000000000000 and it should be ($450.00 * 8% = $36.00). What do I
need to do to get the correct result? Note that if the percent is 2 digits,
e.g. 15.0000000000 then the result is correct. Thanks.

**View Complete Post**

## Problem with calculation in combination with crossjoin