Brow, o case é uma das opções q você tem nesse caso, uma outra seria usar um decode, como nos exemplos abaixo...
Selecionar tudo
SQL> WITH tbl_glufke AS
2 (
3 SELECT 50 RESUMO_TOTAL_SERVICO, 5 TOTAL_VENDEDOR FROM DUAL
4 UNION ALL
5 SELECT 50 RESUMO_TOTAL_SERVICO, 5 TOTAL_VENDEDOR FROM DUAL
6 )
7 SELECT NVL(TRUNC(((SUM(RESUMO_TOTAL_SERVICO ) / DECODE(SUM(TOTAL_VENDEDOR),0,NULL,SUM(TOTAL_VENDEDOR)) )),2),0) PRODUCAO_TOTAL
8 FROM tbl_glufke;
PRODUCAO_TOTAL
--------------
10
Selecionar tudo
SQL> WITH tbl_glufke AS
2 (
3 SELECT 50 RESUMO_TOTAL_SERVICO, 0 TOTAL_VENDEDOR FROM DUAL
4 UNION ALL
5 SELECT 50 RESUMO_TOTAL_SERVICO, 0 TOTAL_VENDEDOR FROM DUAL
6 )
7 SELECT NVL(TRUNC(((SUM(RESUMO_TOTAL_SERVICO ) / DECODE(SUM(TOTAL_VENDEDOR),0,NULL,SUM(TOTAL_VENDEDOR)) )),2),0) PRODUCAO_TOTAL
8 FROM tbl_glufke;
PRODUCAO_TOTAL
--------------
0
Selecionar tudo
SQL> WITH tbl_glufke AS
2 (
3 SELECT 50 RESUMO_TOTAL_SERVICO, 5 TOTAL_VENDEDOR FROM DUAL
4 UNION ALL
5 SELECT 50 RESUMO_TOTAL_SERVICO, 0 TOTAL_VENDEDOR FROM DUAL
6 )
7 SELECT NVL(TRUNC(((SUM(RESUMO_TOTAL_SERVICO ) / DECODE(SUM(TOTAL_VENDEDOR),0,NULL,SUM(TOTAL_VENDEDOR)) )),2),0) PRODUCAO_TOTAL
8 FROM tbl_glufke;
PRODUCAO_TOTAL
--------------
20
[]s!!!