commit 23fa8893a83efa71b061f7b9cb4402c693cc24bc
author rohitwaghchaure <rohitw1991@gmail.com> Thu Mar 22 11:16:00 2018 +0530
committer Nabin Hait <nabinhait@gmail.com> Thu Mar 22 11:16:00 2018 +0530
tree 278f961a107192912e17294796ee16d5edcd5bb1
parent a3714e1678bc7e0cb0c4dc0b10972866c03442da

[Fix] Division by zero issue (#13362)

erpnext/controllers/status_updater.py

diff --git a/erpnext/controllers/status_updater.py b/erpnext/controllers/status_updater.py
index df0fec8..e8e851d 100644
--- a/erpnext/controllers/status_updater.py
+++ b/erpnext/controllers/status_updater.py
@@ -285,7 +285,7 @@
 					ifnull((select
 						ifnull(sum(if(%(target_ref_field)s > %(target_field)s, abs(%(target_field)s), abs(%(target_ref_field)s))), 0)
 						/ sum(abs(%(target_ref_field)s)) * 100
-					from `tab%(target_dt)s` where parent="%(name)s"), 0), 2)
+					from `tab%(target_dt)s` where parent="%(name)s" having sum(abs(%(target_ref_field)s)) > 0), 0), 2)
 					%(update_modified)s
 				where name='%(name)s'""" % args)