crhmac

Problems of Summary fields

Discussion created by crhmac on Mar 20, 2012
Latest reply on Mar 29, 2012 by crhmac

Hi all.

 

I have a problem with subtotal field.

 

I have 3 Fields, total pago, total recebido and saldo for N accounts.

 

Total Pago is a calcutation Sum(saldo_dia_conta_mov_diaria::valor_pago_calculado) field located in a Subsummary

 

Total recebido is a calculation too Sum(saldo_dia_conta_mov_diaria cr::valor_recebido_calculado) both using a relatalionship.

 

Saldo only the diference between Pago - recebido, saldo_inicial_relacao + GetSummary (total_contas_recebidas_cr; conta_para_fluxo_de_caixa) - GetSummary ( total_contas_pagas; conta_para_fluxo_de_caixa)

 

Now I need ai Summary, total of the total pago, more total of the total recebido and total of the Saldo, but if I use example a field in Trailing Grand Summary the Total is always the Summary of total.

 

Exemplo:

 

Account 1 = Total Pago R$ 200,00 Total Recebido R$ 400 saldo = R$ 200,00 OK.

Account 2 = Total Pago R$ 100,00 Total Recebido R$ 400 saldo = R$ 300,00 OK.

 

Total = R$ 300,00 Total = R$ 800,00 Total = R$ 500,00 ( my objetive)

 

But this total Summary Always the total of records in database and dont respect the relationship.

 

I hope has been clear.

 

Tks

Attachments

Outcomes