Excel Forum

Code: Select all

SELECT [Status]
      ,[No_]
      ,[Description]
      ,[Blocked]
	  ,[Item No_]
	  ,Description
	  ,[Sum Qty_ Consumption]
	  ,[Sum Qty_ Consumption] + Quantity as [remining]
	  ,coalesce(case when ([Sum Qty_ Consumption] + Quantity) = 0 then 0
	        when ([Sum Qty_ Consumption] + Quantity) = NULL then [Sum Qty_ Consumption]
			when ([Sum Qty_ Consumption] + Quantity) > 0 then [Sum Qty_ Consumption] + Items_ledger.Quantity
			when ([Sum Qty_ Consumption] + Quantity) < 0 then 0
			end,[Sum Qty_ Consumption]) as [Reserv_Paper] 
  FROM [dbo].[$Production Order] prod_order

Code: Select all

SELECT * FROM 
(
      SELECT [Status]
      ,[No_]
      ,[Description]
      ,[Blocked]
	  ,[Item No_]
	  ,Description
	  ,[Sum Qty_ Consumption]
	  ,[Sum Qty_ Consumption] + Quantity as [remining]
	  ,coalesce(case when ([Sum Qty_ Consumption] + Quantity) = 0 then 0
	        when ([Sum Qty_ Consumption] + Quantity) = NULL then [Sum Qty_ Consumption]
			when ([Sum Qty_ Consumption] + Quantity) > 0 then [Sum Qty_ Consumption] + Items_ledger.Quantity
			when ([Sum Qty_ Consumption] + Quantity) < 0 then 0
			end,[Sum Qty_ Consumption]) as [Reserv_Paper] 
	FROM [dbo].[$Production Order]
  )  prod_order
 WHERE [Reserv_Paper] != 0