District | Purchased (Kgs) | Utilised (Kgs) | Balance (Kgs) | % |
---|---|---|---|---|
{{value.District_Name}} | {{value.qty}} | {{value.usedquantity | number}} | {{res=value.qty*1-value.usedquantity*1 | number}} | {{value.usedquantity/value.qty*100 | number:1}} |
Total | {{tot_qty=(bs_billing_dist_data | sumByColumn:'qty')}} | {{tot_used_qty=(bs_billing_dist_data | sumByColumn:'usedquantity')}} | {{tot_qty-tot_used_qty | number}} | {{tot_used_qty/tot_qty*100 | number:1}} |