Warning: include(../connect/connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\ps\no\_____ps_show_report.php on line 14
Warning: include() [function.include]: Failed opening '../connect/connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\ps\no\_____ps_show_report.php on line 14
| Zone | Target | Actual | +/- | % |
SELECT ts.area as ZONE, Sum(qty_ctn) AS TOT,
(select sum(TTG) from sale_target_all as tg where tg.area=ts.area and tg.period='') as TARGET,
(Sum(qty_ctn)*100)/(select sum(TTG) from sale_target_all as tg where tg.area=ts.area and tg.period='') as 'PTARGET'
FROM transale as ts WHERE (ts.orderdate like '%')
and channel in('CA','CR','MT','IDS')
AND ts.zone=''
GROUP By ts.area
ORDER BY ts.area
Warning: Division by zero in E:\www\mobile\ps\no\_____ps_show_report.php on line 79
| TOTAL | 0.00 | 0.00 | 0.00 | 0.00 |