Hola Foro
tengo un query que me arroja los datos de ventas anuales actuales vs ventas anuales actuales del año pasado, con el porcentaje por cada mes, funiona bien en cantidades pero no en el porcentaje, en teoria si de un mes fue menor la venta deberia de ser negativo el dato peor no me lo arroja tampoco en los positivos, alquien podria decir en que esta mal?
este es el query
Select Distinct Month(T0.DocDate) As 'Mes', IsNull((Select Sum(X.DocTotal -
X.VatSum) As Expr1 From OINV As X
Where Month(X.DocDate) = Month(T0.DocDate) And Year(X.DocDate) = 2010 And
X.DocType = 'I'), 0) - IsNull((Select Sum(Y.DocTotal - Y.VatSum) As Expr1
From ORIN As Y
Where Month(Y.DocDate) = Month(T0.DocDate) And Year(Y.DocDate) = 2010 And
Y.DocType = 'I'), 0) As 'Ventas Año Pasado', IsNull((Select Sum(X.DocTotal -
X.VatSum) As Expr1 From OINV As X
Where Month(X.DocDate) = Month(T0.DocDate) And Year(X.DocDate) = 2011 And
X.DocType = 'I'), 0) - IsNull((Select Sum(Y.DocTotal - Y.VatSum) As Expr1
From ORIN As Y
Where Month(Y.DocDate) = Month(T0.DocDate) And Year(Y.DocDate) = 2011 And
Y.DocType = 'I'), 0) As 'Ventas Año Actual', (IsNull((Select Sum(X.DocTotal
- X.VatSum) As Expr1 From OINV As X
Where Month(X.DocDate) = Month(T0.DocDate) And Year(X.DocDate) = 2011 And
X.DocType = 'I'), 0) - IsNull((Select Sum(Y.DocTotal - Y.VatSum) As Expr1
From ORIN As Y
Where Month(Y.DocDate) = Month(T0.DocDate) And Year(Y.DocDate) = 2011 And
Y.DocType = 'I'), 0)) / (IsNull((Select Sum(X.DocTotal - X.VatSum) As Expr1
From OINV As X
Where Month(X.DocDate) = Month(T0.DocDate) And Year(X.DocDate) = 2010 And
X.DocType = 'I'), 0) - IsNull((Select Sum(Y.DocTotal - Y.VatSum) As Expr1
From ORIN As Y
Where Month(Y.DocDate) = Month(T0.DocDate) And Year(Y.DocDate) = 2010 And
Y.DocType = 'I'), 0)) * 1 As '%'
From OINV As T0
Order By 'Mes'
saludos y gracias a todos