SELECT sum(((pur_qty*pur_price)-discount)+(((pur_qty*pur_price)-discount)*cgst/100)+(((pur_qty*pur_price)-discount)*sgst/100)+(((pur_qty*pur_price)-discount)*igst/100)) as total FROM `tbl_purchase_details` 