@php $totalMB = 0; $subAmount = 0; $vatAmount = 0; $totalAmount = 0; @endphp @foreach ($result as $val) @php $totalMB += $val->bandwith + $val->youtube + $val->facebook + $val->bdix + $val->data; $totalAmount += $val->total_amount; @endphp @endforeach

Location	MB	Sub-Total	VAT Amount	Total Amount
{{ $val->company_name }}	{{ $val->bandwith + $val->youtube + $val->facebook + $val->bdix + $val->data }}	{{ number_format($val->sub_total_amount!='' ? $val->sub_total_amount : $val->total_amount)}} {{-- {{ number_format($val->sub_total_amount) }} --}}	@php $totalAmountVAT = $val->total_amount; if($val->sub_total_amount!=''){ $totalAmountVAT = $val->sub_total_amount; } $VATAmountOnly = 0; if($val->vat!=''){ $VATAmountOnly = ($totalAmountVAT * $val->vat)/100; } $vatAmount += $VATAmountOnly; $subAmount += $totalAmountVAT; @endphp {{ round($VATAmountOnly) }} {{ $val->vat!='' ? '('.$val->vat.'%)' : '('.'0%)'}}	{{ number_format($val->total_amount) }}
Total	{{ $totalMB }}	{{ number_format($subAmount) }}	{{ number_format($vatAmount) }}	{{ number_format($totalAmount) }}