Responder a: Erro ORA 00904 no group by

[ElizaParticipante]

Consegui contornar colocando o AVG.  Testei em um período grande e parece que deu certo.

select cab.codemp, cab.nunota
, CAB.CODTIPOPER
, ITE.CODPROD
, SUM(NVL(ITE.QTDNEG,0)) AS QTDNEGDEV
, AVG( NVL((SELECT C1.PERCCOM AS PERCCOMI FROM AD_COMECOMMERCE C1 WHERE C1.DTAVIGENCIA =
(SELECT max(C2.DTAVIGENCIA) FROM AD_COMECOMMERCE C2 WHERE C2.DTAVIGENCIA <= CAB.DTNEG AND C2.CODEMP = CAB.CODEMP) AND C1.CODEMP = CAB.CODEMP),0)) AS PERCPLAT
FROM TGFCAB CAB
INNER JOIN TGFITE ITE ON ITE.NUNOTA = CAB.NUNOTA
INNER JOIN TGFTOP TPO ON TPO.CODTIPOPER = CAB.CODTIPOPER
where cab.dtneg = ’01/09/2021′
group by cab.codemp, cab.nunota, CAB.CODTIPOPER, ITE.CODPROD