| Zone | Target | Actual | +/- | % |
SELECT area as ZONE, Sum(qty) AS TOT,
SUM(target_qty) as TARGET,
(SUM(qty)*100)/(SUM(target_qty)) as 'PTARGET'
FROM a_saletotal
WHERE period=''
and channel in('CA','CR','MT','IDS')
AND zone=''
GROUP By area
ORDER BY area
Warning: Division by zero in E:\www\mobile\ps\ps_show_report.php on line 77
| TOTAL | 0.00 | 0.00 | 0.00 | 0.00 |