Double values in Aggr and Total Line.

[Ribeiro]

I need to correct the set analysis below because it is folded.

I need to get the amount with the correct name:

Any tips.

IF(Sum(Aggr(Only({$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL), CODIGOPRODUTO,DOCUMENTOFISCALORIGINAL,CODIGOPESSOA,DATAMOVIMENTO1)),
Sum(TOTAL <DOCUMENTOFISCALORIGINAL,CODIGOPESSOA,DATAMOVIMENTO1>{$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL))

[Kushal_Chawda]

Can't open QVW. Can you tell me what are the dimensions and  measures and what is expected?

[Ribeiro · Accepted solution]

DOCUMENTOFISCALORIGINAL,DATAMOVIMENTO1,CODIGOPESSOA,CODIGOVENDEDOR,PESOLIQUIDOPRODUTO