Warning: include(../connect/connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\ps\no\ps_show_report2.php.bak 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_report2.php.bak on line 14
| 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 like '%'
and channel in('CA','CR','MT','IDS')
AND zone=''
GROUP By area
ORDER BY area
Warning: Division by zero in E:\www\mobile\ps\no\ps_show_report2.php.bak on line 78
| TOTAL | 0.00 | 0.00 | 0.00 | 0.00 |