Shouldn't you simply have it other way round (normal price - discount amount):
(Orders.ProdQty * Products.Cost) - ((Orders.Discount / 100) * (Orders.ProdQty * Products.Cost)) AS [Discounted Cost]
or simply:
(Orders.ProdQty * Products.Cost) * (1- (Orders.Discount / 100))