I've created a view, using the following select statement.
As you can see, i've aliased a lot of the columns to make it far more friendly.
I need to return a column on the end of this that is "GrandTotal" and is basically SubTotal + VAT (this VAT column is displayed as a percentage, so need to add % to this)
Thanks for your help.
SELECT
No_ AS CroCode,
Description,
[Vendor Item No_] AS SupplierStockCode,
[Qty_to Receive] AS Qty,
[Unit Cost (LCY)] AS UnitPrice,
[VAT %] AS VATPercent,
ROUND([Unit Cost (LCY)] * [Qty_ to Receive], 2) AS SubTotal
FROM
dbo.TableNameGoesHere