Bom dia amigos.
Criei planilha no RM Labore com a utilização da sentença abaixo, e o problema é que a soma do valor do encargo está acunulando com a soma dos eventos da primeira linha de CASE(???)
após a "s.descricao".
Se alguem puder me indicar o erro na sentença eu agradeço.
Abraços.
----------------------------------
Select s.codigo,
s.descricao,
sum(CASE WHEN F.CODEVENTO IN ('0001','0002','0037','0046','0139', '0195','0141') THEN f.valor ELSE 0 END) /*salarioMes*/,
sum(CASE WHEN E.CODENCARGO IN ('0057') THEN e.valor ELSE 0 END) /*REM. BRUTA*/,
sum(CASE WHEN F.CODEVENTO IN ('0154','0162') THEN f.valor ELSE 0 END) /*AX. CRECHE*/,
sum(CASE WHEN F.CODEVENTO IN ('0228') THEN f.valor ELSE 0 END) /*HE50%*/,
sum(CASE WHEN F.CODEVENTO IN ('0387','0388') THEN f.valor ELSE 0 END) /*HE60%*/,
sum(CASE WHEN F.CODEVENTO IN ('0242') THEN f.valor ELSE 0 END) /*HE65%*/,
sum(CASE WHEN F.CODEVENTO IN ('0124','0377') THEN f.valor ELSE 0 END) /*HE75%*/,
sum(CASE WHEN F.CODEVENTO IN ('0010') THEN f.valor ELSE 0 END) /*HE95%*/,
sum(CASE WHEN F.CODEVENTO IN ('0111') THEN f.valor ELSE 0 END) /*HE100%*/,
sum(CASE WHEN F.CODEVENTO IN ('0113','0291','0294','0331','0332', '0359','378','0391','0214') THEN f.valor ELSE 0 END) /*DSR*/,
sum(CASE WHEN F.CODEVENTO IN ('0116','0329','0439','0360','0357','0358','0136') THEN f.valor ELSE 0 END) /*Ad.Not*/,
sum(CASE WHEN F.CODEVENTO IN ('0149','0186','0240','0212','0076') THEN f.valor ELSE 0 END) /*PREMIO*/,
sum(CASE WHEN F.CODEVENTO IN ('0157') THEN f.valor ELSE 0 END) /*PLR*/,
sum(CASE WHEN F.CODEVENTO IN ('0024','0025','0064','0048','0071', '0258','0277','0281','0121','035','0063','0266','0340','0341','0343','0345') THEN f.valor ELSE 0 END) /*INDENIZATÓRIOS*/
from pfunc p
left join psecao s on p.codcoligada=s.codcoligada and p.codsecao=s.codigo
left join pfencargo e on p.codcoligada=e.codcoligada and p.chapa=e.chapa
and e.mescomp= :PLN_$S$7_N
and e.anocomp= :PLN_$T$7_N
and e.codencargo in('0057')
left join pffinanc f on p.codcoligada=f.codcoligada and p.chapa=f.chapa
and f.mescomp= :PLN_$S$7_N
and f.anocomp= :PLN_$T$7_N
and f.codevento in ('0001','0002','0037','0046','0139','0195','0141','0154','0162','0228',
'0387','0388','0242','0124','0377','0113','0291','0294','0331','0332','0359','378','0391','0214')
Where p.codcoligada= :PLN_$E$2_N
and (p.codsituacao <>'D' or p.datademissao>= :PLN_$E$1_D )
and (p.tipoadmissao<>'T' or p.dttransferencia<= :PLN_$E$1_D )
and (f.valor>=0 or e.valor>=0)
group by s.codigo,
s.descricao