Skip to Content
0
Former Member
Dec 05, 2011 at 04:08 PM

query de ventas anuales

131 Views

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