I need a query to return the totals for the items of a project. The ProjectItems table has the following columns.
So I need it to return Total Cost, List Price and Sell Price.
Total Cost would be the sum of (Qty * Cost) in each row
List Price would be the sum of (Qty * List) in each row
Sell Price would be the sum of ((1 - Discount) * (Qty * List)) in each row