⬅ Back Bill Net Rate Formula.sql
if {TBillItem.Per}="P" THEN (val({TBillItem.Amount})+val({TBillItem.ItemAddAmt})-val({TBillItem.ItemDiscAmt})-val({TBillItem.RDAmt})-val({TBillItem.LessAmt})+val({TBillItem.PackCharge})+val({TBillItem.TransCharge})+val({TBillItem.AddLess1Amt})+val({TBillItem.AddLess2Amt}))/val({TBillItem.Pcs})
ELSE if {TBillItem.Per}="M" THEN (val({TBillItem.Amount})+val({TBillItem.ItemAddAmt})-val({TBillItem.ItemDiscAmt})-val({TBillItem.RDAmt})-val({TBillItem.LessAmt})+val({TBillItem.PackCharge})+val({TBillItem.TransCharge})+val({TBillItem.AddLess1Amt})+val({TBillItem.AddLess2Amt}))/VAL({TBillItem.Meters})