Last post Sep 16, 2016 03:03 AM by firstname.lastname@example.org
Sep 15, 2016 01:19 PMemail@example.com|LINK
Our Requirement is calculate Total Amount which will be Sum Of [Basic Amount] + [SalesTax] + [VAT Tax] +[Excise Duty]
Required Result :
Could you please help in writing a Query to Pull the data from Pending_Invoice Table and show the Total Amount against the Base Invoice Number as Expalined ?
Let me know, if you need any clarifications from my end.
Sep 15, 2016 01:31 PM|Strauby|LINK
SELECT SUM(ISNULL(BasicAmount,0) + ISNULL(SalesTax,0) + ISNULL(VAT,0) + ISNULL(ExciseDuty,0)) AS Total FROM Pending_Invoice WHERE InvoiceNo LIKE 'MS208/11513%'
Sep 16, 2016 03:03 AMfirstname.lastname@example.org|LINK
Thank you for your immediate reply.