0 THEN 1 ELSE 0 END) AS LZ_CTS, SUM(CASE WHEN AgoMx > 0 THEN 1 ELSE 0 END) AS MX_CTS, SUM(CASE WHEN AgoMz > 0 THEN 1 ELSE 0 END) AS MZ_CTS, SUM(CASE WHEN AgoVe > 0 THEN 1 ELSE 0 END) AS VE_CTS, SUM(AgoLz) AS LZ_MONTO, SUM(AgoMx) AS MX_MONTO, SUM(AgoMz) AS MZ_MONTO, SUM(AgoVe) AS VE_MONTO FROM VT9000_IngresosPorClientePorMes"; //Ejecutar Query $result = sqlsrv_query($con_comercial, $sql); $result2 = sqlsrv_query($con_comercial, $sql2); ?>

INGRESOS MEXICO AGO/2018

Actualizar Regresar
". "". "". ""; while($row = sqlsrv_fetch_array($result)){ $monto = number_format($row['AgoMx'],2); $porcent = (100 * $row['AgoMx'])/$row2['MX_MONTO']; $porcent = number_format($porcent, 2); $i = $i + 1; echo "". "". "". "". ""; } sqlsrv_free_stmt($result); sqlsrv_free_stmt($result2); sqlsrv_close($con_comercial); ?>
No Cliente Porcentaje
".$row2['MX_CTS']."Total".(100 * $row2['MX_MONTO'])/$row2['MX_MONTO']." %
".$i."".$row["Cliente"]."".$porcent." %