We have a query, that last column called shortage, right now it shows the postives and the Zero values as well as the negitives. Trying to get it show only when negitive.
SELECT T2.ItemCode, T3.ItmsGrpNam,T2.ItemName, sum(case when T0.[Status] ='R' then (isnull(T1.PlannedQty,0)) else 0 End) as 'Released' , T2.OnHand , (T2.OnHand-sum(case when T0.[Status] ='R' then (isnull(T1.PlannedQty,0)) else 0 End)) as 'Shortage' FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OITM T2 ON T1.ItemCode=T2.ItemCode LEFT OUTER JOIN OITB T3 ON T2.ItmsGrpCod=T3.ItmsGrpCod WHERE T0.[Status] ='R' and T1.ItemCode Like '2%' Group by T2.ItemCode, T3.ItmsGrpNam,T2.ItemName,T1.PlannedQty, T2.OnHand