Could it be the additional minus before the ISNULL on the copper line which is inverting the value " - A.[Copper Turnover Value][highlight="#ffff11"] * - ISNULL[/highlight](dbo.RebateAgreements.Copper, 0)) ...